Dela via


SQL Server Integration Services

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. 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 a rich set of built-in tasks and transformations; tools for constructing packages; and the Integration Services service for running and managing packages. You can use the graphical Integration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

Browse Content by Life Cycle

Small File Folder Icon Product Evaluation

Small File Folder Icon Getting Started

Small File Folder Icon Planning and Architecture

Small File Folder Icon Development

Small File Folder Icon Deployment

Small File Folder Icon Operations

Small File Folder Icon Security and Protection

Small File Folder Icon Troubleshooting

Small File Folder Icon Technical Reference

Browse Content by Role

Information Worker icon (small) Information Worker

Administrator icon (small) Administrator

Developer icon (small) Developer

Architect icon (small) Architect

Component Interfaces with Integration Services
Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

Visit the Integration Services page on MSDN

For automatic notification of these updates, subscribe to the RSS feeds available on the page.