Data Transformation Services is a powerful tool introduced with SQL Server 7.0. It is a versatile tool that enables developers to design packages that transfer and transform the data efficiently between two data sources.
Using Data Transformation Services, you can
Select any data source, not necessarily SQL Server, if you have an ODBC driver or OLE DB provider to access its data.
Select any data destination (it doesn't have to be SQL Server) if you have the ODBC driver or OLE DB provider to connect to it.
Define the transformation process to convert the source data into the structure and format required on destination.
Define complex tasks using Transact-SQL or any scripting language.
Transfer database objects between ...