Script ALL DTS packages on server to text files

  • Comments posted to this topic are about the item Script ALL DTS packages on server to text files

  • how can i ammed this script to cater for pwd protected dts packages

    thanks

  • I've tried running this script using trusted connection in a command prompt window and absolutely nothing happens! No error messages returned. How do I debug it?

  • 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

  • I know this is an old thread, but I thought I'd ask anyway...

    This script doesn't seem to produce the same output that you would get if you save the package as a .bas file. Can I rely on this to tell me what I need - which is, what packages contain references to a certain database? That's all I really need, no more detail than that at this point.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply