Post reply

How to find if an object is used by which DTS

  • September 15, 2008 at 9:54 am

    #127402

    I am working on sql 2005. I am able to find where certain objects are used in everything, but DTS packages. I am looking for the dts packages where a stored proecedure might be used. Is there anyway I can do that in sql server 2005? We have migrated the DTS packages in 2005. Thanks in advance for help.

  • September 15, 2008 at 10:02 am

    #871856

    These are legacy DTS packages, not SSIS packages, right? The only option I know of to search DTS packages is to save them as VB files and edit them. I think I've seen a script on this site that writes out all packages on an instance, maybe this one: http://qa.sqlservercentral.com/scripts/Miscellaneous/31613/.

    Greg

  • September 15, 2008 at 10:06 am

    #871867

    Thanks a lot I will check the thread.

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

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