SSIS Interview Questions

SSIS Interview Questions

SQL Server Integration Services Interview Questions 

Part 1 | Part 2Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | Part 9 | Part 10 

Part 1 - 10 out of 100 Questions

1. What is ETL?

ETL means Extract, Transformation and Load. It is a process of extracting data from multiple sources, transformed data as per business requirement and load it in one single place or multiple places. Generally it is used to create Data Marts and Data Warehouses.

Read More... (This link is going to be open in a new windows)

Read With Images...

Watch a Video... (This link is going to be open in a new windows on our video blog.)

2. What are important components of ETL tool?

3. Named different ETL tools available in market? Which ETL tool you have used as an ETL Developer?

Complete list of ETL tools are available here.

4. What is SSIS ? Explain its Architecture ?

SQL Server Integration Services or SSIS is a windows base GUI tool used for creating or maintaing data migration projects. It is a microsoft product and comes with a part of Business Intelligence Development studio (BIDS). 


Watch a Video...

5. Do you know about DTS? How it is different from SSIS?

6. How SSIS is used in SQL Server?

7. What is SSIS Package ?

SSIS Package is an organized collection of data connections, control flow elements, data flow tasks, events handlers ...

Read More ...

Watch a Video ...

8. How to create a new SSIS Package ?

You can use BIDS or Import and Export Wizard to create a SSIS Package. For more detail refer below links.

Read More ...

Watch a Video ...

9. How to create a SSIS Package without using BIDS ?

You can create a SSIS Package with Import and Export wizard available in SQL Server Management Studios (SSMS).


Watch a Video...

10. How to protect your SSIS Package ?

SQL Serve Interview Question Part 2

Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | Part 9 | Part 10 

SSIS Personal Interview Questions

SSIS Complete Tutorial

SSIS Practical Scenarios

SSIS Tips and Tricks

Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first