Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script ALL DTS packages on server to text files Expand / Collapse
Author
Message
Posted Saturday, September 29, 2007 9:47 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, November 13, 2007 10:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, April 15, 2009 8:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Saturday, April 25, 2009 4:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 3, 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
Posted Wednesday, February 1, 2012 12:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 23, 2014 8:03 AM
Points: 11, Visits: 106
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 »

Add to briefcase

Permissions Expand / Collapse