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