Copying Data Using the Data Transformation Services Wizards

The Data Transformation Services (DTS) wizards allow the user to create DTS packages interactively that can be used to import, export, validate, and transform heterogeneous data using OLE DB and ODBC, and copy schema and data between relational databases.

The DTS Import and DTS Export wizards allow the user to:

• Specify any custom settings supported by the OLE DB provider used to connect to the data source or destination.
• Copy an entire table or the results of an SQL query, such as queries involving joins of multiple tables, or distributed queries.
• Build a query using the Query Builder within the wizards. This allows users inexperienced with the SQL language to build queries interactively.
• Change the name, data type, size, precision, scale, and nullability of a column when copying the source to the destination (where a valid data type conversion applies).
• Specify transformation rules that govern how data is copied between columns of different data type, size, precision, scale, and nullability.
• Execute a Microsoft® ActiveX® script (Microsoft Visual Basic® Scripting Edition (VBScript) or Microsoft JScript®) that can modify (transform) the data when copied from the source to the destination, or perform any operation supported by the VBScript or JScript languages.
• Save the DTS package to the Microsoft SQL Server™ msdb database, Microsoft Repository, or a COM-structured storage file.
• Schedule the DTS package for later execution.

For more information about using the DTS Import and DTS Export wizards, see Data Transformation Services Import and Export Wizards.

See Also