• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 876
  • Last Modified:

Convert DTS Packages to Readable Code

Hello,
I dont work much with DTS packages but is there a way to be able to convert a DTS package into code or some readable format? Here is the scenario, say we have about 100 DTS packages and we want to know how many packages use a specific login or how many packages would be affected if  a change is made to a specific table. If i can convert the package to say VB code, for example or sql scripts which we can query, that would be awesome!

Thanks!
0
super786
Asked:
super786
1 Solution
 
Chris MangusDatabase AdministratorCommented:
Open the DTS package in the DTS Designer and choose 'Package' and 'Save As'.  Change the Location to 'Visual Basic File'.  Choose a file name and click on OK.  You'll end up with a Visual Basic file that you can easily read.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now