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.
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.
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
Generate packages to txt or readable format
Posted - 01/18/2010 : 02:28:20
