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 void LookupAdvanced(LibCF.DataFlow dataFlow, LibDF.OutputWrapper output, Lib.ConnectionManager connection)
{
LibDF.Lookup lkp = new LibDF.Lookup(
"Lookup", connection, "LOOKUP SQL",
LibDF.NoMatchBehaviour.RedirectRowsToNoMatchOutput,
LibDF.CacheType.Partial)
.AddComponent(dataFlow);
new LibDF.Path(output, lkp.DefaultInput).Connect(dataFlow);
lkp.AddReadOnlyInputColumn("inputColumn");
lkp.AddLookupMapping(new LibDF.LookupMapping("inputColumn", "lookupColumn"));
LibDF.LookupAdvancedParameters advPars = new LibDF.LookupAdvancedParameters("select Advanced SQL Query");
advPars.AddParameter("Parameter");
lkp.SetAdvancedParameters(advPars);
}