When running from a command prompt (for example, using cscript), you have to add a line to invoke the "Main" function; for example,

i = Main ()

Also, of course, you need to specify the correct server name and login credentials.

You might also need to add this line at the beginning:

const DTSSQLStgFlag_UseTrustedConnection = 256

I debug vbs scripts by inserting

wscript.echo "checkpoint 001"

etc. at various places throughout the script.

You can call me if you need more help, 888-946-7878.

- Tom Warfield

Warfield Consulting