sql server dts: Ok, So I've successfully exported our DTS packages into vb files and
corrected all the login info and creator info for installing them onto
our production server.

So... how do I go about getting those packages onto the new server?
All I have access to is Visual Studio .NET is there some way to run
these vb6 files? They won't run in the vbscript engine in sql server.

help?

Hello wolfen42 at gmail.com,


So I doubt they will run on .Net but the way you would save them back in
VB Classic is to uncomment/comment the lines of code that say something like

goPackage.Execute
goPackage.SaveToSQLServer





Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

Thanks Alan.

I eventually realized that I couldnt use vb files to save the packages
as other users here still need to be able to use the Enterprise Manager
DTS package design interface.

It also didnt help that I can't get access to VB 6.0 on this machine...
(grin)