Post reply

ssis package summary

  • October 1, 2009 at 12:45 pm

    #210363

    Hi,

    I have over 100 packages and I need to summarize the sources and destination tables for all these packages. Is there a quick way to do this?

    e.g.

    package1 has DFT with excel src and table1 as dest

    package2 doesnt have DFT

    package3 has DFT with table1 as src and table2 as dest

    summary should be

    pkg name src dest

    --------- ----- ------

    package1 excel table1

    package3 table1 table2

    thanks.

  • October 1, 2009 at 1:11 pm

    #1060651

    I don't know of such a tool. If you're comfortable hacking XML, you possibly could create your own documentation tool to read the DTSX file and extract that kind of information, but that would require a lot of work and rework, IMHO.

    hth,

    Tim

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

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

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