O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Data Transformation Services

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required