SQL Server Integration Services, or SSIS, is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks and workflow applications.
SSIS features a data warehousing tool used for data extraction, transformation and loading (ETL), and can also be used to automate the maintenance of SQL Server databases.
The SSIS features an Import/Export Wizard that lets users create packages capable of moving data from a single source to a destination with no transformations. This can be done from a variety of source types to a variety of destination types, including text files and other SQL Server instances.