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