SSIS Interview Questions

Ques. What is SSIS ?

Ans. SSIS or SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server, which can be used to accomplish a broad range of data migration tasks.

Ques. Mention what are the important components of SSIS package?

Ans. The important component in SSIS package are • Data flow • Control flow • Package explorer • Event handler

Ques. Explain what is Solution Explorer in SSIS?

Ans. Solution Explorer in SSIS Designer is a screen where you can view and access all the data sources, data sources views, projects, and other miscellaneous files.

Ques. Explain what does it mean by data flow in SSIS?

Ans. Data flow in SSIS is nothing but the flow of data from the corresponding sources to the target destinations.

Ques. Define what is “task” in SSIS?

Ans. Task in SSIS is a very much similar to the method of any programming language that represents or carries out an individual unit of work. Tasks are categorized into two categories • Control Flow Tasks • Database Maintenance Tasks

Post Question