Post reply

DTS

  • February 12, 2009 at 10:14 am

    #72677

    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?

  • February 12, 2009 at 10:39 am

    #943041

    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]

  • February 12, 2009 at 11:55 am

    #943082

    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