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)



Find more PRO+ content and other member only offers, here.

1 comment


Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:


File Extensions and File Formats

Powered by: