SSIS – Part 1
SSIS Interview Questions and Answers for Experienced and Freshers
Here we are publishing series of posts on SSIS Interview questions with answers for experienced and freshers . Below is the series 1.
Q. Define SSIS?
Ans:
SQL Server Integration Services — commonly known as SSIS is the new platform that was introduced in SQL Server 2005, for data transformation and data integration solutions. This replaced the DTS in SQL Server 2000.
Q. Name a few SSIS components?
Ans:
- Integration Services Projects
- Integration Services Packages
- Control Flow Elements
- Data Flow Elements
- Integration Services Connections
- Integration Services Variables
- Integration Services Event Handlers
- Integration Services Log Providers
Q. What is a project and Package in SSIS?
Ans:
Project is a container for developing packages. Package is nothing but an object. It implements the functionality of ETL — Extract, Transform and Load — data.
Q. What are the 4 elements (tabs) that you see on a default package designer in BIDS?
Ans:
Control Flow, Data Flow, event Handler and package explorer. (Parameters – 2012 Data Tools)
Q. What is a Control flow and Data Flow elements in SSIS?
Ans:
