public ISLookupOutputColumn(ISLookupComponent parentComponent, LookupOutputColumnOperation lookupColumnOperation, string lookupColumnName, string outputAlias = "", string columnToReplace = "") { LookupOperation = lookupColumnOperation; _lookupComponent = parentComponent; if (LookupOperation == LookupOutputColumnOperation.Add) { OutputColumn = new ISOutputColumn(_lookupComponent, _output.Name, String.IsNullOrEmpty(outputAlias) ? LookupColumn : outputAlias); LookupColumn = lookupColumnName; OutputColumn.ErrorRowDisposition = RowDisposition.RD_NotUsed; TruncationRowDisposition = RowDisposition.RD_FailComponent; } if (LookupOperation == LookupOutputColumnOperation.Replace) { if (String.IsNullOrEmpty(columnToReplace)) { } else { InputColumn = new ISInputColumn(_lookupComponent, _input.Name, columnToReplace, UsageType.UT_READWRITE); InputColumn.Name = outputAlias; LookupColumn = lookupColumnName; InputColumn.ErrorOrTruncationOperation = "Copy Column"; InputColumn.ErrorRowDisposition = RowDisposition.RD_NotUsed; TruncationRowDisposition = RowDisposition.RD_FailComponent; } } }
/// <summary> /// Add a Output Column to a script component /// </summary> /// <param name="parentComponent"></param> /// <param name="outputName"></param> /// <param name="outputColumnName"></param> public ISScriptComponentOutputColumn(ISScriptComponent parentComponent, string outputName, string outputColumnName) { _parentComponent = parentComponent; _output = parentComponent.GetOutputFromName(outputName); OutputColumn = new ISOutputColumn(parentComponent, _output.Name, outputColumnName); ErrorRowDisposition = RowDisposition.RD_NotUsed; TruncationRowDisposition = RowDisposition.RD_NotUsed; }
protected void SetErrorOutputForAllColumns(RowDisposition errorRowDisposition, RowDisposition truncationRowDisposition) { foreach (Pipe.IDTSOutputColumn100 column in SSISDefaultOutput.OutputColumnCollection) { column.TruncationRowDisposition = (Pipe.DTSRowDisposition)truncationRowDisposition; column.ErrorRowDisposition = (Pipe.DTSRowDisposition)errorRowDisposition; } }
public ISOutputColumn(ISPipelineComponent parentComponent, string outputName, string outputColumnname, RowDisposition errorRowDisposition, RowDisposition truncationRowDisposition) : this(parentComponent, outputName, outputColumnname) { OutputColumn.ErrorRowDisposition = DtsUtility.EnumAToEnumB <RowDisposition, DTSRowDisposition>(errorRowDisposition); OutputColumn.TruncationRowDisposition = DtsUtility.EnumAToEnumB <RowDisposition, DTSRowDisposition>(truncationRowDisposition); }
public void AddLookUpColumnIntoDataFlow(string lookupColumnName, string lookupColumnNameAlias, RowDisposition truncationRowDisposition, SSISDataType dataType, int length, int precision, int scale, int codePage, string inputColumnToReplace = null) { if (String.IsNullOrEmpty(inputColumnToReplace)) { ISOutputColumn oc = new ISOutputColumn(this, MatchOutput_m.Name, lookupColumnName, RowDisposition.RD_NotUsed, truncationRowDisposition); oc.SetDataTypeProperties(dataType, length, precision, scale, codePage); SetCustomPropertyToOutputColumn(MatchOutput_m.Name, lookupColumnName, "CopyFromReferenceColumn", lookupColumnName); oc.Name = String.IsNullOrEmpty(lookupColumnNameAlias) ? lookupColumnName : lookupColumnNameAlias; } else { ISInputColumn ic = new ISInputColumn(this, _input.Name, inputColumnToReplace, UsageType.UT_READWRITE); SetCustomPropertyToInputColumn(ic.Input, ic.InputColumn, "CopyFromReferenceColumn", lookupColumnName); ic.Name = String.IsNullOrEmpty(lookupColumnNameAlias) ? lookupColumnName : lookupColumnNameAlias; _renamedInputCols.Add(new string[] { inputColumnToReplace, ic.Name }); } }
public new FlatFileSource SetErrorOutputForAllColumns(RowDisposition errorRowDisposition, RowDisposition truncationRowDisposition) { base.SetErrorOutputForAllColumns(errorRowDisposition, truncationRowDisposition); return(this); }
public ISInputColumn ReplaceWithDerivedColumn(string columnName, string expression, string expressionCols, RowDisposition errorRowDisposition = RowDisposition.RD_FailComponent, RowDisposition truncationRowDisposition = RowDisposition.RD_FailComponent) { if (!(String.IsNullOrEmpty(expressionCols))) { SetUsageTypeToReadForExpressionCols(expressionCols); } ISInputColumn ic = new ISInputColumn(this, _input.Name, columnName, UsageType.UT_READWRITE, errorRowDisposition, truncationRowDisposition); SetCustomPropertyToInputColumn(_input, GetInputColumn(_input.Name, columnName), "Expression", expression); SetCustomPropertyToInputColumn(_input, GetInputColumn(_input.Name, columnName), "FriendlyExpression", expression); return(ic); }
public ISOutputColumn AddDerivedColumn(string columnName, string expression, string expressionCols, SSISDataType dataType, int length = 0, int precision = 0, int scale = 0, int codePage = 0, RowDisposition errorRowDisposition = RowDisposition.RD_FailComponent, RowDisposition truncationRowDisposition = RowDisposition.RD_FailComponent) { if (!(String.IsNullOrEmpty(expressionCols))) { SetUsageTypeToReadForExpressionCols(expressionCols); } ISOutputColumn oc = new ISOutputColumn(this, this.GetOutputFromIndex(0).Name, columnName, errorRowDisposition, truncationRowDisposition); oc.SetDataTypeProperties(dataType, length, precision, scale, codePage); SetCustomPropertyToOutputColumn(oc.Output, oc.OutputColumn, "Expression", expression); SetCustomPropertyToOutputColumn(oc.Output, oc.OutputColumn, "FriendlyExpression", expression); return(oc); }
internal void SetErrorRowDisposition(RowDisposition rowDispostion) { SSISObject.ErrorRowDisposition = (Pipe.DTSRowDisposition)rowDispostion; }
public ISInputColumn(ISPipelineComponent parentComponent, string inputName, string inputColumnName, UsageType usageType, RowDisposition errorRowDisposition, RowDisposition truncationRowDisposition) : this(parentComponent, inputName, inputColumnName, usageType) { ErrorRowDisposition = errorRowDisposition; TruncationRowDisposition = truncationRowDisposition; }