DTS Package Details

  • Hi, I have 2000 DTS packages in production. Packages are created by various users. Each package in turn is

    pointing to different databases. Is there any way to find out which userid/password/Database is used inside DTS

    to connect to database?

    Thanks,

    Ramesh.

  • Not really. You could save each package as a VB file and search them or you can open each one.

  • Is there any way to automate this like opening each job and saving it to VBS to check which connection is used?

  • Search SSC for "scripting packages". There are a couple of scripts in the Script section that describe how to output all packages.

    Greg

  • I'm sure there is. Likely you're use a VBScript and open the packages with the DTS objects, then save them out as a different file. you'd have to look around for the exact features of opening a package and then saving off.

    I'd try here: http://www.sqldts.com/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply