Explore BrainMass

Explore BrainMass

    Data Transformation Services

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 4, 2021, 9:58 pm ad1c9bdddf

    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.