Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2010-01-18 : 02:28:20
|
| 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 - 2010-01-19 : 07:50:10
|
| Any updates? your help is highly appreciated. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-19 : 11:02:26
|
| you can save them as VB files. that's as close as you're going to get. |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2010-01-19 : 22:40:40
|
| 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. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-19 : 23:27:58
|
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 |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2010-01-20 : 00:21:58
|
| 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. |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2010-01-30 : 10:24:35
|
| any help? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-30 : 14:38:03
|
| I wiped the drive that I had it on...need to find the backup. |
|
|
|
|
|
|
Generate packages to txt or readable format