Example #1
0
 public ISConditionalSplitOutput(ISConditionalSplitComponent parentComponent, string outputName, int evaluationOrder, string condition, string conditionColumns = "")
 {
     _parentComponent = parentComponent;
     _output          = new ISOutput(parentComponent, outputName);
     EvaluationOrder  = evaluationOrder;
     SetFriendlyExpression(condition, conditionColumns);
 }
Example #2
0
        internal void SetFriendlyExpression(ISOutput condOutput, string condition, string conditionColumns = "")
        {
            IDTSInput100  _input   = ComponentMetaData.InputCollection[0];
            List <string> colArray = new List <string>();

            if (String.IsNullOrEmpty(conditionColumns))
            {
                foreach (IDTSVirtualInputColumn100 column in _input.GetVirtualInput().VirtualInputColumnCollection)
                {
                    if (condition.Contains(column.Name))
                    {
                        colArray.Add(column.Name);
                    }
                }
            }
            else
            {
                colArray = conditionColumns.Split(',').ToList();
            }

            foreach (string column in colArray)
            {
                SetInputColumnDTSUsageType(_input, column, UsageType.UT_READONLY);
            }

            condOutput.SetCustomProperty("FriendlyExpression", condition);
        }
Example #3
0
        public ISOutput AddConditionalOutput(string outputName, int evaluationOrder, string condition, string conditionColumns = "")
        {
            ISOutput condOutput = new ISOutput(this, outputName);

            condOutput.SetCustomProperty("EvaluationOrder", evaluationOrder);
            SetFriendlyExpression(condOutput, condition, conditionColumns);
            return(condOutput);
        }
Example #4
0
 public ISLookupComponent(ISDataFlowTask parentDataFlowTask, string componentName) :
     base(parentDataFlowTask, "Microsoft.Lookup", componentName)
 {
     _numberOfInputsAllowed  = 1;
     _numberOfOutputsAllowed = 2;
     _renamedInputCols       = new List <string[]>();
     MatchOutput             = new ISOutput(this, 0);
     NoMatchOutput           = new ISOutput(this, 1);
 }
Example #5
0
 public void ConnectToAnotherPipelineComponent(ISPipelineComponent sourceComponent, ISOutput sourceComponentOutput, int inputIndex = 0)
 {
     ConnectToAnotherPipelineComponent(sourceComponent.Name, sourceComponentOutput.Name, inputIndex);
 }
Example #6
0
 /// <summary>
 /// A ctor that accepts a parent data fllow, a name for the component and the previous component (and output) to which this is connected
 /// </summary>
 public ISScriptComponent(ISDataFlowTask parentDataFlowTask, string componentname, ISPipelineComponent sourceComponent, ISOutput sourceOutput, int thisComponentInput = 0) :
     this(parentDataFlowTask, componentname)
 {
     if (sourceOutput != null)
     {
         ConnectToAnotherPipelineComponent(sourceComponent.Name, sourceOutput.Name, thisComponentInput);
     }
     else
     {
         ConnectToAnotherPipelineComponent(sourceComponent.Name, sourceComponent.GetOutputFromIndex(0).Name, thisComponentInput);
     }
 }
Example #7
0
 public ISConditionalSplitComponent(ISDataFlowTask parentDataFlowTask, string componentName,
                                    ISPipelineComponent sourceComponent,
                                    ISOutput sourceOutput) :
     this(parentDataFlowTask, componentName, sourceComponent, sourceOutput.Name)
 {
 }
Example #8
0
 public ISMulticastOutput(ISMulticastComponent parentComponent, string outputName)
 {
     _parentComponent = parentComponent;
     _output          = _parentComponent.AddOutput(outputName);
 }