SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications.
Defining SQL Server Integration Services
Exploring the need for migrating diverse data
The role of business intelligence (BI) Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
Using Visual Studio for rapid application development
Running wizards for basic migrations
Creating packages for complex tasksDistinguishing between data flow pipeline and package runtime
Executing packages on the client side or hosted in the SSIS service