SSIS Interview Questions and Answers

Slowly Changing Dimensions (SCD), What are the types of SCD.

Data Source which You have worked on or type of Data Sources in SSIS

Event handlers in SSIS

Transformations In SSIS

Union All and Merge In SSIS

Have you worked on ODS Layers?

I have one excel sheet and I want to send data to the destination based on even and odd values

Lookup Transformation in SSIS

How to deploy a package

The folder has 10 files read one by one, read one by one also if there is any failure need to start the job from POF also there should not be any duplicate
what is the approach that you will follow

Scenario I just want to get the updated records from a table, assume that there is no last modified by column, and you don’t need to compare with some other destination table, but I need to get the list of the count of updated records.

Difference Between DTS and DTSX

What are SSIS Expressions

What is a MERGE Transformation

what are SSIS containers?

Checkpoint in SSIS.

Checkpoint in SSIS.