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
);
}
