Summary
DTS helps SQL Server 2000 users reach a new level of simplicity. The possibilities are vast and difficult to imagine in the context of one chapter. However, you should now have an understanding of how DTS can make it easy to move information in and out of other data sources (especially SQL Server).
We have shown that the DTS package is a self-contained element that can be executed, scheduled, and shared. You have seen that the DTS Wizard can help you get up-to-speed quickly by developing packages for simple imports and exports. You have also been introduced to the power of the DTS Designer for complex workflow-oriented transformation application. Also, COM-based interfaces allow you to create highly customized imports, exports, and transformations ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
