SQL Server Integration Services allows you to build enterprise-level data integration solutions and data transformations. Integration Services can be used to solve complex business problems. It allows you to copy or download files, load data warehouses, cleanse and mine data, and manage SQL Server objects.
Integration Services can extract, transform, and load data from a variety of sources including flat files, XML data files, and relational sources.
Integration Services comes with a rich set if tasks and transformations, graphical tools to build packages, and the Integration Services Catalog database where you can store, run and manage packages.
The graphical Integration Services tools can be used to create solutions without having to write any code. To create custom tasks and packages programmatically, you can also program the extensive Integration Services model.