How do you want to start your DTS Package today?
February 26, 2000
There are several methods that can be used to start your DTS Packages, depending on what you want to do. Each method has advantages and disadvantages. I will illustrate several methods that I use, and offer my views on each.
If the examples here don't fit your application then pick the one you like best, and change it until it does.
Listed below in no particular order are the key technologies/methods that can be used -
When to Use What?
How you use the above methods, or rather what method you use in a given solution is often a case of personal preference.
Command Shell or Batch file
In this article I have often mentioned several methods of doing the same thing. Usually the first method is the simplest and best. Some may ask why I bothered to mention the others, just to try and confuse you perhaps? Often the simplest and most obvious method does not fit when taken in context with the rest of your solution. One reason for this is that you can often re-use code or objects in several places within a solution yet in one instance the method is not the most obvious. It is up to you to decide if re-use and thus less code to maintain outweighs the ease of choosing the simple method. I have also tried to promote a bit of lateral thinking, as I'm sure you know, the answer is always out there (..well nearly always), it's just a case of finding the damn thing!