SSIS Interview Questions

Below is the list of interview questions available for SSIS on category basis.You can click on links for answers.

SSIS Deployment Interview Questions

Question: How to deploy the packages SSIS?
Question: Where a package does deploys in Integration service database?
Question: What is Manifest file in SSIS?
Question: What is File System Deployment?
Question: how to back up or retrieve the SSIS package?
Question: What are the different databases in Integration services while login through SSMS?

SSIS Transactions Interview Question

Question: How to implement Transaction in SSIS package?
Question: Can we implement transactions in SSIS package?
Question: What are different transaction Options in SSIS?
Question: How to implement isolation level in SSIS package?
Question: What is chaos in isolation level options in SSIS?
Question: Case study how isolation works in SSIS?

SSIS Checkpoint Interview Questions

Question: What are the checkpoints in SQL Server?
Question: What is checkpoint file?
Question: How do checkpoints behave in case of For Loop and For Each loop?

SSIS Control Flow Tasks Interview Questions

Question: Difference between Dataflow Task and Control Flow Task?
Question: What is the control flow Task?
Question: What is the difference between for Loop and for each loop container?
Question: What are different iterations in For Each LOOP container?
Question: What is Sequence Container and how it works?
Question: Difference between File System and FTP Task?
Question: What is Execute SQL Task?
Question: Difference between Execute SQL Task and Execute TSQL-Statement Task?

SSIS Control Flow: Analysis Services Interview Questions

Question: What is slowly changing dimensions?
Question: Let’s say there are changes made in table A and that need to be replicated in data warehouse for
same record. Table A exists in both db already and whatever changes done to it need to be reflected in data
warehouse. Create the package for it.
Question: What is Analysis Services Execute DDL task?
Question: What is Analysis Services Execute DDL task?
Question: What is Data profiling Task?
Question: What is data mining Query Task?

SSIS Dataflow Task Interview Questions

Question: What is data flow Task?
Question: What is the different type of data sources in Dataflow task?
Question: What is Difference between Ado.net Destination and Record set Destination?
Question: Explain XML data source and how it works?
Question: What all the transformation you have used in dataflow task?
Question: Explain alternative method to use XML as a source?
Question: What is fuzzy Lookup and Fuzzy Grouping? Explain difference?
Question: Data Conversion and Derived column explain?
Question: What is Multicast?
Question: Difference between Union All and Merge Join?
Question: Difference between OLEDB Destination, SQL Server Destination and SQL Server Compact
Destination?
Question: Difference between Merge and Merge Join?
Question: What is Cache Transformation? How to use it Explain?
Question: What is Oledb Command transformation in SSIS used for?
Question: Explain the Lookup Transformation?
Question: Difference between the data type DT_STR and DT_WSTR?
Performance Tuning:
Question: Explain the performance tuning tips for SSIS Package?
Question: What are Blocking, Partial blocking and Row version transformation?
Question: What is parallelism in SSIS how to implement it?
Question: What are the properties which can be modified to maintain buffer size?
Question: Properties to modified packet size on network?
Question:

SSIS Script Task Interview Questions

Question: What is Script Task?
Question: What is Script Component?
Question: How to use script component as Source and Destination?
Question: What are the languages available for coding in Script Task?
Question: How to Handle Object Variable in Script Task?
Question: What are the steps to use a package Variable in Script Task?

SSIS General Interview Questions

Question: What is Config File in SSIS?
Question: What are the different types of Config options available in SSIS package?
Question: Explain Connection Manager?
Question: How to change the connection manager values at run time?
Question: How to add logging in SSIS?
Question: What are the ways to store logs in SSIS packages?
Question: What is annotation in SSIS Package?

SSIS Security Interview Questions

Question: How to implement the security in SSIS package?
Question: What is the protection Level in SSIS package and what are the different types of protection available?
Question: How to implement database level package security?
Question: What is event handler Tab in Design window?
Question: What is SSIS package?
Question: What are the other part tabs of package design window?

Keywords:

SSIS Interview Questions, SSIS Interview Questions and answer , SQL server interview questions, SQL Server interview questions and answers.