How to get mapped column names in custom pipeline component?
Hi, I created a custom pipeline component which is connected to a destination component ( and the columns are mapped to the destination) Source-->Custom Pipeline component --> Destination Source has 3 columns say C1,C2,C3 Destination has 3 Column say Col1, Col2, Col3 C1---Col1 C2---Col2 C3---Col3 How can I get the column names mapped in the destination. I need this information within the pipeline component. THanks -Sajin
November 16th, 2010 10:07am

Sajin, I don't think you can do what you are asking. A upstream component has no way of interrogating a downstream component. The mapping between the input of the destination and the output of the transformation is not available to either component. Look at how you build packages programatically and it should be clearer. Perhaps if you explain what you are trying to achive we may be able to help. Have a look at some sample components, it can often help, http://ssisctc.codeplex.com/ http://www.sqlis.com | http://www.konesans.com
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 11:45am

Hi, Since the downstream cannot be read with in the code. I would like to read what are all the connection managers defined with in the ETL package. Can I get that using SSIS object model? My idea is to create a custom UI for my pipeline component where I will display the connection manager in one drop down, when one selected, another dropdown will populate all the table instance with in that connection. Hope you got the scenario? Thanks -Sajin
November 16th, 2010 12:43pm

Perhaps it would be better if you described what your component was attempting to do. Why does it need the metadata from the eventual destination? To directly answer your question - yes, you can get at connection managers within your component - but you would have no idea which connection manager the subsequent destination was using. You'd have to guess, or rely on the ETL developer to select the same one. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 9:57pm

I think being in a user interface changes things somewhat, you can do much more. You can list connections and create connections. See IDtsConnectionService. You can get a reference to it in the from constructore. Search for some samples. You can also get reference to the host via the IServiceProvider, and that may allow you to investigate other components. The point of this functionalty is to allow a UI to interact with other components in the way that the SCD component does. I cannot find a reference right now, but sure it came along in 2005 SP1, I remember asking how to do this.http://www.sqlis.com | http://www.konesans.com
November 17th, 2010 3:47am

Ah - but the SCD component doesn't "interact" with the other components. Sure, it uses the interface class to create those components, but once they're created, it doesn't touch them. If it could, then they might have made a better editing experience ;) Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 11:49am

It doesn't, but I think it could. I'm sure it woudl be possible, as I can't see how you can create components and yet not be able to edit them. I haven't done it, and its been a long time since I looked at this area, can't even find the interface name now...http://www.sqlis.com | http://www.konesans.com
November 19th, 2010 10:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics