i'm creating a Lookup programmatically. But i can't find out how to assign the ConnectionManager that references the lookup data.
Do you have an example for me?
Many thanks in advance.
Stefan L.
Use the RuntimeConnectionCollection of the component (IDTSComponentMetaData90). This is the same pattern as a you use for a source or destination, but any component can specifyc runtime connections, as indeed the lookup does.
component.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(package.Connections[0]);
|||Hi,
Great! It works! Thank you very much!
Stefan L.|||
I am new to SSIS programming and having trouble using JoinToReferenceColumns (
http://msdn2.microsoft.com/en-us/library/ms136014.aspx#lookup ) property of lookup transformation. Can you please post a code sample?
No comments:
Post a Comment