public Lookup AddComponent(DataFlow dataFlowTask)
{
base.AddComponent(dataFlowTask.SSISObject, "DTSTransform.Lookup");
Component.RuntimeConnectionCollection[0].ConnectionManager = SSIS.DtsConvert.GetExtendedInterface(ConnectionManager.SSISObject);
Component.RuntimeConnectionCollection[0].ConnectionManagerID = ConnectionManager.SSISObject.ID;
ComponentWrapper.SetComponentProperty("CacheType", (int)CacheType);
ComponentWrapper.SetComponentProperty("SqlCommand", SQLCommand);
if (MatchBehaviour == NoMatchBehaviour.FailComponent || MatchBehaviour == NoMatchBehaviour.RedirectRowsToNoMatchOutput)
{
ComponentWrapper.SetComponentProperty("NoMatchBehavior", MatchBehaviour);
}
else if (MatchBehaviour == NoMatchBehaviour.IgnoreFailure)
{
ComponentWrapper.SetComponentProperty("NoMatchBehavior", NoMatchBehaviour.FailComponent);
this.MatchOutput.SetErrorRowDisposition(RowDisposition.RD_IgnoreFailure);
}
else
{
ComponentWrapper.SetComponentProperty("NoMatchBehavior", NoMatchBehaviour.FailComponent);
}
return(this);
}
public Lookup SetAdvancedParameters(LookupAdvancedParameters advanced)
{
this.Advanced = advanced;
if (Advanced.HasSqlCommandParam)
{
ComponentWrapper.SetComponentProperty("SqlCommandParam", Advanced.SqlCommandParam);
if (Advanced.HasParameters)
{
string parameterMap = string.Join(";", Advanced.Parameters.Select(par => "#" + FindSSISInputColumn(par).LineageID.ToString())) + ";";
ComponentWrapper.SetComponentProperty("ParameterMap", parameterMap);
}
}
if (Advanced.HasCacheSize32Bit)
{
ComponentWrapper.SetComponentProperty("MaxMemoryUsage", Advanced.CacheSize32Bit);
}
if (Advanced.HasCacheSize64Bit)
{
ComponentWrapper.SetComponentProperty("MaxMemoryUsage64", Advanced.CacheSize64Bit);
}
if (Advanced.HasNoMatchCachePercentage)
{
ComponentWrapper.SetComponentProperty("NoMatchCachePercentage", Advanced.NoMatchCachePercentage);
}
return(this);
}
public OLEDBCommand AddComponent(DataFlow dataFlowTask)
{
base.AddComponent(dataFlowTask.SSISObject, "DTSTransform.OLEDBCommand.3");
Component.RuntimeConnectionCollection[0].ConnectionManager = SSIS.DtsConvert.GetExtendedInterface(ConnectionManager.SSISObject);
Component.RuntimeConnectionCollection[0].ConnectionManagerID = ConnectionManager.SSISObject.ID;
ComponentWrapper.SetComponentProperty("SqlCommand", SQLCommand);
return(this);
}
public RowCount AddComponent(DataFlow dataFlowTask)
{
base.AddComponent(dataFlowTask.SSISObject, "DTSTransform.RowCount.3");
ComponentWrapper.SetComponentProperty("VariableName", Variable.QualifiedName);
return(this);
}