Post reply

how to find the package that is updating a specific table

  • January 4, 2011 at 12:39 pm

    #245012

    i have a table that is being populated with updated data from some source (i do not know whats the source ) and the table uses a package to get updated , now is there a way i can find out which package is updating this table , we have like so many packages so i cant really click each package ,

    to find out from where my table is being updated , please help

    thanks

    regards

    greg

  • January 4, 2011 at 12:57 pm

    #1269174

    Are you referring to a SSIS package? If so, I think the the package ID is part of the application name. If it is you run a trace on updates the the table in question and make sure to select application name and one of the columns.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • January 4, 2011 at 1:04 pm

    #1269177

    ok WILL DO

    thanks

    regards

    greg

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

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