SQL Server Integration Services (SSIS)Intervew Q & A.

SSIS
1: What is SSIS? How it is related with SQL Server.

SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server.
This is a platform for Integration and Workflow applications. It is known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and multidimensional data sets.

2: What are the tools associated with SSIS?

We use Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) to work with Development of SSIS Projects.
We use SSMS to manage the SSIS Packages and Projects.

3: What are the differences between DTS and SSIS

Data Transformation Services

SQL Server Integration Services

Limited Error Handling

Complex and powerful Error Handling

Message Boxes in ActiveX Scripts

Message Boxes in .NET Scripting

No Deployment Wizard

Interactive Deployment Wizard

Limited Set of Transformation

Good number of Transformations

NO BI functionality

Complete BI Integration

63:Can you name five of the Perfmon counters for SSIS and the value they provide?

• SQLServer:SSIS Service
• SSIS Package Instances
• SQLServer:SSIS Pipeline
• BLOB bytes read
• BLOB bytes written
• BLOB files in use
• Buffer memory
• Buffers in use
• Buffers spooled
• Flat buffer memory
• Flat buffers in use
• Private buffer memory
• Private buffers in use
• Rows read
• Rows written