Data Transformation Services
DTS is a very powerful and sophisticated tool to help you import or manipulate data.
Uses of DTS
- Import data from other databases
- Transform data to correct inconsistencies
- Convert currency, date formats
To begin with call for the DTS Wizard go to your :
SQL Enterprise Manger
Select the server object, Tools (Menu), Wizards, Data Transformation Services.