Extracting package information from SSIS

Hi all,

I am supposed to maintain a bunch of excels documenting all the mappings I'm doing in SSIS. The excels have the following format:

Target Field | Target Type | Source Table | Source Field | Source Type | Transformation Rule

Apart from being incredibly tedious, it is hard to keep every excel current, as there are other people adding and taking information from the database model.

I plan to extract this information from SSIS and create the excels dinamically, but, apart from parsing the .dtsx for each package, I see no other way of getting what I need.

Any suggestions on how I should do this? Is there an easier way?

Cheers,

David LealThe SSIS object model provides access to all aspects of the package, you can use it from both managed and unmanaged code. Also, take a look as SQL BI Metadata Samples that has similar goal of documenting the package, you may find some of its code useful for your project.|||Thank you very much, Michael. I'll look into that.