SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Generate packages to txt or readable format
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

carumuga
Posting Yak Master

174 Posts

Posted - 01/18/2010 :  02:28:20  Show Profile  Reply with Quote
Hi,

I have couple of packages deployed in the server. Can you please the way to generate all these packages into text or readable format so that i can identify the object that is being referenced in the package rather than manually opening each and every package as it bit tedious task to perform it. Anyway, i did tried the following query but resulted in the encryped format.

EXEC MASTER..XP_CMDSHELL 'DTSRUN.EXE /S TEST /E /N "TEST" /F "E:\DTS\TEST.BAS" /!X'.

Thanks in advance.

carumuga
Posting Yak Master

174 Posts

Posted - 01/19/2010 :  07:50:10  Show Profile  Reply with Quote
Any updates? your help is highly appreciated.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/19/2010 :  11:02:26  Show Profile  Visit russell's Homepage  Reply with Quote
you can save them as VB files. that's as close as you're going to get.

Edited by - russell on 01/19/2010 11:02:51
Go to Top of Page

carumuga
Posting Yak Master

174 Posts

Posted - 01/19/2010 :  22:40:40  Show Profile  Reply with Quote
I dont want to open each packages and click "save as" to save the packages to the file system. Is there any query where it can convert all dts packages to the file system which is in readable format.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/19/2010 :  23:27:58  Show Profile  Visit russell's Homepage  Reply with Quote
nope. i wrote a program a few years back that saves them all to .dts files (binary format). it's fast too

if you're realllllly interested I could post the source code and see if anyone can figure out how to make it save as .bas (visual basic) files. assuming i can still find the source
Go to Top of Page

carumuga
Posting Yak Master

174 Posts

Posted - 01/20/2010 :  00:21:58  Show Profile  Reply with Quote
That would be great help if you could post the source code and let me have a look if i can tweak the code to work.
Go to Top of Page

carumuga
Posting Yak Master

174 Posts

Posted - 01/30/2010 :  10:24:35  Show Profile  Reply with Quote
any help?
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/30/2010 :  14:38:03  Show Profile  Visit russell's Homepage  Reply with Quote
I wiped the drive that I had it on...need to find the backup.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000