﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Gordo  / Script ALL DTS packages on server to text files / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Thu, 23 May 2013 22:13:38 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Script ALL DTS packages on server to text files</title><link>http://www.sqlservercentral.com/Forums/Topic404582-744-1.aspx</link><description>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.</description><pubDate>Wed, 01 Feb 2012 12:13:15 GMT</pubDate><dc:creator>marykdba</dc:creator></item><item><title>RE: Script ALL DTS packages on server to text files</title><link>http://www.sqlservercentral.com/Forums/Topic404582-744-1.aspx</link><description>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 = 256I 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</description><pubDate>Sat, 25 Apr 2009 04:14:59 GMT</pubDate><dc:creator>andy plotkin</dc:creator></item><item><title>RE: Script ALL DTS packages on server to text files</title><link>http://www.sqlservercentral.com/Forums/Topic404582-744-1.aspx</link><description>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?</description><pubDate>Wed, 15 Apr 2009 08:43:02 GMT</pubDate><dc:creator>iain.bell</dc:creator></item><item><title>RE: Script ALL DTS packages on server to text files</title><link>http://www.sqlservercentral.com/Forums/Topic404582-744-1.aspx</link><description>how can i ammed this script to cater for pwd protected dts packages thanks</description><pubDate>Tue, 13 Nov 2007 10:13:09 GMT</pubDate><dc:creator>sam_twum</dc:creator></item><item><title>Script ALL DTS packages on server to text files</title><link>http://www.sqlservercentral.com/Forums/Topic404582-744-1.aspx</link><description>Comments posted to this topic are about the item [B]&lt;A HREF="/scripts/Miscellaneous/31613/"&gt;Script ALL DTS packages on server to text files&lt;/A&gt;[/B]</description><pubDate>Sat, 29 Sep 2007 21:47:39 GMT</pubDate><dc:creator>Gordo-174357</dc:creator></item></channel></rss>