How can Data Transformation Services (DTS) be used for data manipulation in SQL Server?© BrainMass Inc. brainmass.com March 4, 2021, 9:58 pm ad1c9bdddf
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 ...
Data Transformation Services for data manipulation in SQL Server is explained.