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 ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
