Script ALL DTS packages on server to text files

  • Gordo-174357

    Mr or Mrs. 500

    Points: 581

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

  • sam_twum

    Valued Member

    Points: 71

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

    thanks

  • iain.bell

    SSC Rookie

    Points: 49

    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?

  • andy plotkin

    SSC Journeyman

    Points: 84

    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

  • marykdba

    Mr or Mrs. 500

    Points: 574

    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 5 (of 5 total)

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