DTS

  • I am looking for a way to query all of the DTS packages for a specific database name. I started by looking at the MSDB.dbo.SysDTSPackages table but it doesn't offer what I'm after.

    Anybody come across this before?

  • Have a look at this article:

    http://www.dbazine.com/sql/sql-articles/larsen8

    It's not quite what you're after, as it only looks for connection names, but it could point you in the right direction

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • Thanks! I'm giving it a try.

Viewing 3 posts - 1 through 2 (of 2 total)

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