Most Common Uses of SQL Server Integration Services
Merging data from heterogeneous data stores SSIS can be used to take data from different systems, extract the data, and then merge the data into a consistent source.
Populating data warehouses and data marts With SSIS, updates of large amounts of data can be performed frequently.
Cleaning and standardizing data With SSIS, abbreviations and data structures (names and addresses) can be processed to agree with corporate conventions.
Building business intelligence into data transformation SSIS can be used for data summarization, conversion, or distribution based on data values.
Automating Data Transfers Rarely are data transfer processes a one-time thing. SSIS packages can be stored and executed when needed. They can also be scheduled using SQL Server Agent jobs.