public void MapInput(string inputName, string externalColumnName, Lookup.MapType mapType) { this.SetInputUsageType(inputName, DTSUsageType.UT_READONLY); string property = (mapType == MapType.JoinToReferenceColumn) ? "JoinToReferenceColumn" : "CopyFromReferenceColumn"; ComponentInstance.SetInputColumnProperty( Component.InputCollection[0].ID, Component.InputCollection[0].InputColumnCollection[inputName].ID, property, externalColumnName ); }
public void MapOutput(string outputName, string externalColumnName, Lookup.MapType mapType) { ComponentInstance.InsertOutputColumnAt( Component.OutputCollection[0].ID, Component.OutputCollection[0].OutputColumnCollection.Count, outputName, outputName); string property = (mapType == MapType.JoinToReferenceColumn) ? "JoinToReferenceColumn" : "CopyFromReferenceColumn"; ComponentInstance.SetOutputColumnProperty( Component.OutputCollection[0].ID, Component.OutputCollection[0].OutputColumnCollection[outputName].ID, property, externalColumnName ); }