Category Archives: SSIS Interview Questions and Answers

Maintenance Tasks are the task which can be used to maintain database administration activities. IT contains the task which performs the SQL Server agent tasks. SSIS contains the task for backup, restore and job executions functionality of SQL server management … Continue reading →

Question: How to create the deployment utility? Answer:Deployment utility can be created by right click on solution explorer setting create deployment utility to true.   Question: How to deploy the packages SSIS? Answer: When you build the package by clicking … Continue reading →

Question: What is event handler Tab in Design window? Answer: In event handlers table error handling of package can be done. It has different functions which executes when there any event occurs in package such as task failed, task execution … Continue reading →

Question: What is SSIS package? Answer: SSIS package is an entity which performs ETL task in SSIS. Extract the data transform it create flow and load it in destination. Question: What is the control flow Task? Answer: Control flow task … Continue reading →

This post contain the interview questions for sql server inegration services. I am posting these questions in multiple series.I have provided the answers but read other study material or books on line to get more conceptual knowledge.   SSIS Interview … Continue reading →