Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). Maximize Your Use of DTS Packages   Article Abstract: (Michael Schmalz) There are many tasks that can be completed by DTS Packages other than just importing and exporting data. This article explores two of them that can be very useful in a number of situations.   Read this article...

Related Articles - For Members. All Articles By Author How to troubleshoot DTS problems DTS Q&A From The Webcast ActiveX for Database Administration DTS Optimization Tips SQL Glue: DTS for the DBA SQL Server 2000 DTS Part 10 - DTS Designer Tasks - The Data Driven Query Task SQL Server 2000 DTS Part 9 - DTS Designer Tasks SQL Server 2000 DTS Part 7 - DTS Designer Tasks: the ActiveX Script task SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables

RE: Maximize Your Use of DTS Packages
(posted: 11/16/2004 8:57:13 AM)
If you are using a vb.net console app in the execute task.. how do you set the return code. it looks like the return code when things go well isn't always 0. it is a negitive number for me. How do I set the return code in vb.net so that the execute task see the execution as a success

RE: Maximize Your Use of DTS Packages
(posted: 11/16/2004 3:14:20 PM)
Hi, Liked your article on Maximize Your Use of DTS Packages. I wouldnt mind an article on ActiveX Script tasks as I have been unable to find a lot of details about. thx

RE: Maximize Your Use of DTS Packages
(posted: 11/17/2004 2:47:27 PM)
Hi, Liked your article on Maximize Your Use of DTS Packages. I would also like to see an article on ActiveX Script tasks.

RE: Maximize Your Use of DTS Packages
(posted: 11/23/2004 4:28:18 AM)
Hello, great article on the DTS Packages. The idea about an article on ActiveX Script tasks is very interesting.
//Andren-Sweden