Easiest way to set up DTS packages for the novice or infrequent user is run Enterprise Manager and then use the Import Data or Export Data Wizard to set up a prototype - Don't forget that you should check the box before the wizard finishes to save the jobs in a Local Package.
The saved package can then be run on demand or scheduled as necessary.
If you really want to see what the package diagram etc looks like, use the Design Package.
If you need to change the package, it is usually easier to delete the old one, and create new using the Wizard, rather than using the package editor.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.