Script ALL DTS packages on server to text files

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gordo » Script ALL DTS packages on server to text...

Script ALL DTS packages on server to text files

Rate Topic

Display Mode

Topic Options

Author

Message

Gordo-174357

Posted Saturday, September 29, 2007 9:47 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:46 PM
Points: 19, Visits: 68

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

Post #404582

sam_twum

Posted Tuesday, November 13, 2007 10:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 28, 2007 2:08 AM
Points: 1, Visits: 6

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

thanks

Post #421678

iain.bell

Posted Wednesday, April 15, 2009 8:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 13, 2009 5:46 AM
Points: 1, Visits: 7

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?

Post #697595

andy plotkin

Posted Saturday, April 25, 2009 4:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, April 03, 2011 4:24 PM
Points: 2, Visits: 39

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

Post #704413

marykdba

Posted Wednesday, February 01, 2012 12:13 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 07, 2012 2:48 PM
Points: 11, Visits: 105

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.

Post #1245264

« Prev Topic | Next Topic »

Permissions