October 1, 2009 at 12:45 pm
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
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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply