| title | SQL Server Integration Services | |||||||
|---|---|---|---|---|---|---|---|---|
| description | Learn about SQL Server Integration Services, Microsoft's platform for building enterprise-level data integration and data transformations solutions. | |||||||
| author | chugugrace | |||||||
| ms.author | chugu | |||||||
| ms.date | 08/17/2023 | |||||||
| ms.service | sql | |||||||
| ms.subservice | integration-services | |||||||
| ms.topic | overview | |||||||
| helpviewer_keywords |
|
|||||||
| keywords | SSIS |
[!INCLUDEsqlserver-ssis]
SQL Server [!INCLUDEssISnoversion] is a platform for building enterprise-level data integration and data transformations solutions. Use [!INCLUDEssISnoversion] to solve complex business problems. For example:
- Copy or download files
- Load data warehouses
- Cleanse and mine data
- Manage [!INCLUDEssNoVersion] objects and data
[!INCLUDEssISnoversion] 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.
[!INCLUDEssISnoversion] includes:
- A rich set of built-in tasks and transformations.
- Graphical tools for building packages.
- An SSIS Catalog database to store, run, and manage packages.
You can use the graphical [!INCLUDEssISnoversion] tools to create solutions without writing a single line of code. You can also program the extensive [!INCLUDEssISnoversion] object model to create packages programmatically and code custom tasks and other package objects.
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.