Post reply

Script ALL DTS packages on server to text files

  • September 29, 2007 at 9:47 pm

    #178304

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

  • November 13, 2007 at 10:13 am

    #750758

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

    thanks

  • April 15, 2009 at 8:43 am

    #978135

    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?

  • April 25, 2009 at 4:15 am

    #983919

    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

  • February 1, 2012 at 12:13 pm

    #1441375

    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