Microsoft SSIS (SQL Server Integration Services)

Contributor(s): Jessica Sirkin

Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool that is built into Microsoft's SQL Server database. It can be used for a variety of integration-related tasks, such as analyzing and cleansing data and running extract, transform and load processes to update data warehouses.

SSIS can extract, transform and consolidate data from multiple relational databases as well as sources such as XML data files and flat files, then load the processed information into an enterprise data warehouse or other target systems. It includes a set of tools for developing and testing integration programs, called SQL Server Data Tools, plus a server component for deploying and running the programs. In addition, Microsoft's SQL Server Management Studio software is incorporated into SSIS for managing and monitoring integration routines.

Microsoft SSIS was introduced with SQL Server 2005 as a replacement for an earlier integration tool called Data Transformation Services. In SQL Server 2014, a data import and export wizard and a set of packaged data source connectors are included in all editions of the database. But users have to buy the Standard, Business Intelligence or Enterprise editions to get the SSIS designer and runtime components as well as basic data profiling tools and pre-built transformations. Advanced adapters and transformations are only available in the Enterprise edition.

This was last updated in August 2014

Continue Reading About Microsoft SSIS (SQL Server Integration Services)

Dig Deeper on Microsoft SQL Server Integration Services (SSIS)

Join the conversation


Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Hi, if we want to consolidate a large amount of data coming from 20 sites in a Main Database, creating a communication cycle every 60 minutes to each branch, do you recomend SSIS? Thank you, Luis
Hi, I'm tasked with moving SQL Server data into DB2. Is SSIS a viable option?


File Extensions and File Formats

Powered by: