• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 813
  • 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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