As you can see from the sample in this article, DTS packages are a quick and easy way to create reusable objects to work with data.

DTS is one of the many features of SQL Server that can be used to create a professional set of objects to make your everyday workings with data easier and more streamlined. Just like databases, DTS packages can also be exported, so they can be shared amongst multiple servers.

If you've never used DTS packages before, then I'd encourage you to take some time playing around with all of the connection and task objects in the DTS designer. They're a bit tricky to figure out at first, but you should be able to come to grips with them quickly using this article and the links/books shown below.

________________________________________________________________________

Support Material

This article contains a support file. To download the attached support file, please click here.

Related Links

• http://www.asp101.com/articles/carvin/dts/default.asp


• http://www.asptoday.com/content/articles/20011022.asp


• http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;q252987

Related Books

• Beginning SQL Server 2000 Programming
• Professional SQL Server 2000 Database Design
• Professional SQL Server 2000 Programming
• Professional Windows DNA Building

By: Tim Pabst
Published: 01st Feb 2002

	1 2 3 4 5 6