SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data Transformation Services) that exists in SQL Server 2000.
What is SSIS?
Why we need SSIS?
The main uses of SSIS package are,
Comparison of SQL Server Editions for SSIS
ETL Process ETL (Extract, Transform, and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. ETL involves the following tasks.
Implementation
Step 1
Step 2
Step 3
Step 4
What is Lookup?
Lookup is a Synchronous Transformation that allows you to perform an equi-join between values in the transformation input and values in the reference dataset, similar to T-SQL. This transformation is used to join two datasets at a time. To join more than two datasets, we need to put multiple Lookup transformations, similar to a T-SQL join condition.
Step 5
Step 6
Introducing Microsoft SQL Server 2016