What is SSIS?
SSIS, or SQL Server Integration Services, is a tool for data migration most commonly utilized to create and maintain a data warehouse.
Migrating data is generally done with a process known as an ETL (Extract, transform, and load). This involves ingesting data from one or more source(s), converting it to the desired format and finally sending it to a destination that is often a data warehouse.
An SSIS project is broken down into smaller units of work called packages that are executed individually. Packages are typically organized and grouped according to their destination, such as the table they are loading data into, rather than their sources. This is because a package may create all of the necessary output for a single table in a data warehouse while coming from multiple sources.
Different parts of an SSIS package include:
Connection(s): sources and destinations…