O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The DTS Framework

DTS introduces a set of new database objects and tools to help with the movement of information from place to place. Simple wizards provide the typical question-and-answer approach to importing or exporting data. The DTS Designer gives more knowledgeable users the ability to create more complex transformations that utilize many tables and advanced workflow techniques. DTS provides you the access to the underlying transformation engine via COM objects. This allows you to build complete import, export, or transformation applications using any Component Object Model (COM) enabled environment such as Visual Basic, a Windows scripting host, or Active Server Pages. You can also save DTS packages as Visual Basic code to incorporate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required