Explore BrainMass
Share

Data Transformation Services

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

How can Data Transformation Services (DTS) be used for data manipulation in SQL Server?

© BrainMass Inc. brainmass.com March 21, 2019, 7:18 pm ad1c9bdddf
https://brainmass.com/computer-science/sql/data-transformation-services-287305

Solution Preview

Microsoft DTS is a data manipulation tool.

It could be used for moving data between various formats and systems such as databases, spreadsheets, and even HTML. On can use Import/Export Wizard that is included with DTS for these operations .

Using DTS one can copy tables to FTP sites, and even script his/her own tasks.

DTS use example
===========
* Choose an ODBC data source to read data from.
* Then select an ODBC data source to convert the data to. You are then ...

Solution Summary

Data Transformation Services for data manipulation in SQL Server is explained.

$2.19