Post reply

Need a quickest way to find the ETL Job that loads a specific table

  • September 27, 2007 at 9:53 am

    #153862

    We have so many ETL jobs in our project. Some of the jobs are extracting data from source table and loading directly to the target. My question is how to find the ETL Job that is using a particular source table. For eg: I have a table a in the source which is loading tablea in the target.

    How can find the ETL job that is using table a. There are no naming conventions where I can identify quickly. Please advice.

  • September 27, 2007 at 10:21 am

    #736845

    All SSIS packages are purely XML. Do a text search in the folder or each file for your source table name.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • September 27, 2007 at 10:37 am

    #736852

    Thanks for your response. Is there a place for package metadata available ?

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

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