August 24, 2009 at 11:47 am
I've got a large SSIS package that is basically a lot of data flows from one set of tables to another, with a tiny bit of business logic inside. I've been asked to add any tables missing from the flow and wanted to know if there was any way to get a list of all the component names within a component and/or package.
The Wizard created the list and so I have object names like "Destination 10 - COURSE_SECTION" By extension, is there a way to get to the properties of the components as well? I'm hoping the object model has a way to access it.
Thanks in advance
August 24, 2009 at 11:59 am
I've managed to answer my own question, with the help of Jaime Thomson:
August 24, 2009 at 12:24 pm
I spoke too soon. The blog indicates how to do it in DTS, but not SSIS. The SSIS object model doesn't seem to provide that information. Am I missing something?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply