Data Transformation Services

Importing and exporting data is handled through the DTS (Data Transformation Services) folder in EM. From here, complex data transfer and manipulation tasks can be performed using the DTS Designer pictured in Figure 4.18.

Figure 4.18. The DTS Designer.


Simple data import and export tasks also can be created using the Import and Export Wizards, which can be accessed from the All Tasks menus of the DTS folder, the databases, or individual tables. DTS has another associated folder in EM called Metadata Services. If DTS packages have been saved to the MSDB database, the metadata, or data about data, concerning the package can be browsed through here. Data Transformation Services is covered in detail in Chapter 20, "Importing and Exporting SQL Server Data Using BCP and DTS."

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features