Post reply

Table Reference in DTS Packages

  • October 12, 2006 at 1:43 pm

    #62447

    Hello,

    Is there an efficient way to discover DTS packages where references are made to a specific table and its fields within the packages?

    I am in the process of setting up indexes on a table named FMLog. I need to know which packages contain WHERE clauses where the field(s) comes from the FMLog table.

    Thank you for your help!

    CSDunn

  • October 12, 2006 at 4:59 pm

    #665611

    The easiest thing to do is save the packages as VB file, edit it and search for the string.  I believe that I've seen something in the script section of this site that will save all the packages in an instance to VB files.

    Greg

    Greg

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

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