SQL Server Integration Services

Applies to: yesSQL Server (all supported versions) yes SSIS Integration Runtime in Azure Data Factory

SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

Capabilities

Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Integration Services includes:

You can use the graphical Integration Services tools to create solutions without writing a single line of code. You can also program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

Get started

You can start by installing SQL Server Integration Services, which is part of SQL Server setup.

For installation instructions and guidance, see Install Integration Services.

info_tip Resources