/// <summary>
/// ctor that accepts the parent data flow task and a name for the row component
/// </summary>
/// <param name="parentDataFlowTask"></param>
/// <param name="componentName"></param>
private ISSortComponent(ISDataFlowTask parentDataFlowTask, string componentName) :
base(parentDataFlowTask, "Microsoft.Sort", componentName)
{
_numberOfInputsAllowed = 1;
_numberOfOutputsAllowed = 1;
_input = ComponentMetaData.InputCollection[0];
}
/// <summary>
/// an extended ctor that also connects to another component
/// </summary>
/// <param name="parentDataFlowTask"></param>
/// <param name="componentName"></param>
/// <param name="sourceComponent"></param>
/// <param name="sourceOutputName"></param>
public ISSortComponent(ISDataFlowTask parentDataFlowTask, string componentName, ISPipelineComponent sourceComponent,
string sourceOutputName = "") :
this(parentDataFlowTask, componentName)
{
// After adding hte derived column transformation, connect it to a prevoius component
if (String.IsNullOrEmpty(sourceOutputName))
{
ConnectToAnotherPipelineComponent(sourceComponent.Name);
}
else
{
ConnectToAnotherPipelineComponent(sourceComponent.Name, sourceOutputName);
}
// set all usage to READONLY for all;
string[] viCols = new string[_input.GetVirtualInput().VirtualInputColumnCollection.Count];
for (int i = 0; i < viCols.Length; i++)
{
ISInputColumn ic = new ISInputColumn(this, _input.Name, _input.GetVirtualInput().VirtualInputColumnCollection[i].Name, UsageType.UT_READONLY, RowDisposition.RD_NotUsed, RowDisposition.RD_NotUsed);
SetCustomPropertyToInputColumn(_input, GetInputColumn(_input.Name, ic.Name), "NewComparisonFlags", 0);
SetCustomPropertyToInputColumn(_input, GetInputColumn(_input.Name, ic.Name), "NewSortKeyPosition", 0);
}
/*foreach (IDTSVirtualInputColumn100 vc in _input.GetVirtualInput().VirtualInputColumnCollection)
* {
* Console.WriteLine("Working on " + vc.Name);
* ISInputColumn ic = new ISInputColumn(this, _input.Name, vc.Name, UsageType.UT_READONLY, RowDisposition.RD_NotUsed, RowDisposition.RD_NotUsed);
* SetCustomPropertyToInputColumn(_input, GetInputColumn(_input.Name, ic.Name), "NewComparisonFlags", 0);
* SetCustomPropertyToInputColumn(_input, GetInputColumn(_input.Name, ic.Name), "NewSortKeyPosition", 0);
* }*/
}
public ISConditionalSplitComponent(ISDataFlowTask parentDataFlowTask, string componentName) :
base(parentDataFlowTask, "Microsoft.ConditionalSplit", componentName)
{
_numberOfInputsAllowed = 1;
_numberOfOutputsAllowed = -1;
this.DefaultOutputName = "DefaultOutput";
}
/// <summary>
/// ctor that accepts the parent data flow task and a name for the row component
/// </summary>
/// <param name="parentDataFlowTask"></param>
/// <param name="componentName"></param>
public ISDerivedColumnComponent(ISDataFlowTask parentDataFlowTask, string componentName) :
base(parentDataFlowTask, "Microsoft.DerivedColumn", componentName)
{
_numberOfInputsAllowed = 1;
_numberOfOutputsAllowed = 1;
_input = ComponentMetaData.InputCollection[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);
}
/// <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);
}
}
public ISConditionalSplitComponent(ISDataFlowTask parentDataFlowTask, string componentName, ISPipelineComponent sourceComponent,
string sourceOutputName = "") :
this(parentDataFlowTask, componentName)
{
// After adding the transformation, connect it to a previous component
if (String.IsNullOrEmpty(sourceOutputName))
{
ConnectToAnotherPipelineComponent(sourceComponent.Name);
}
else
{
ConnectToAnotherPipelineComponent(sourceComponent.Name, sourceOutputName);
}
}
public ISLookupComponent(ISDataFlowTask parentDataFlowTask, string componentName, ISPipelineComponent sourceComponent,
string sourceOutputName = "") :
this(parentDataFlowTask, componentName)
{
// After adding hte derived column transformation, connect it to a prevoius component
if (String.IsNullOrEmpty(sourceOutputName))
{
ConnectToAnotherPipelineComponent(sourceComponent.Name);
}
else
{
ConnectToAnotherPipelineComponent(sourceComponent.Name, sourceOutputName);
}
}
public ISAdoNetSourceComponent(ISDataFlowTask parentDataFlowTask, string componentname, ISConnectionManager cm, bool connectionIsOffline = false) :
this(parentDataFlowTask, componentname)
{
if (!(connectionIsOffline))
{
if (cm != null)
{
AssignConnectionManager(cm);
}
else
{
System.Console.WriteLine("WARN::: No Connection Manager is attached. Please use the AssignConnectionManager method to assign a Connection Manager.");
}
}
}
public ISAdoNetDestinationComponent(ISDataFlowTask parentDataFlowTask, string componentName,
ISPipelineComponent sourceComponent,
string sourceOutputName = "") :
this(parentDataFlowTask, componentName)
{
if (String.IsNullOrEmpty(sourceOutputName))
{
ConnectToAnotherPipelineComponent(sourceComponent.Name);
}
else
{
ConnectToAnotherPipelineComponent(sourceComponent.Name, sourceOutputName);
}
InitDefaults();
}
public ISScriptComponent(ISDataFlowTask parentDataFlowTask, string componentname, string sourceComponentName, int sourceComponentOutputIndex = 0, int inputCollectionIndex = 0) :
this(parentDataFlowTask, componentname)
{
ConnectToAnotherPipelineComponent(sourceComponentName, sourceComponentOutputIndex, inputCollectionIndex);
}
public ISAdoNetSourceComponent(ISDataFlowTask parentDataFlowTask, string componentname) :
base(parentDataFlowTask, "Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter, Microsoft.SqlServer.ADONETSrc, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91", componentname)
{
InitDefaults();
}
public ISOleDbDestinationComponent(ISDataFlowTask parentDataFlowTask, string componentname) :
base(parentDataFlowTask, "Microsoft.OleDbDestination", componentname)
{
//InitDefaults();
ExternalColumnInputColumnMap = new List <ExternalColumnInputMap>();
}
/// <summary>
/// ctor that accepts the parent data flow task, a name for the component
/// </summary>
/// <param name="parentDataFlowTask"></param>
/// <param name="componentname"></param>
/// <param name="componentDescription"></param>
public ISScriptComponent(ISDataFlowTask parentDataFlowTask, string componentname) :
base(parentDataFlowTask, "Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91", componentname)
{
}
public ISFlatFileSourceComponent(ISDataFlowTask parentDataFlowTask, string componentname) :
base(parentDataFlowTask, "Microsoft.FlatFileSource", componentname)
{
InitDefaults();
}
public ISConditionalSplitComponent(ISDataFlowTask parentDataFlowTask, string componentName,
ISPipelineComponent sourceComponent,
ISOutput sourceOutput) :
this(parentDataFlowTask, componentName, sourceComponent, sourceOutput.Name)
{
}
/// <summary>
/// ctor that accepts the parent data flow task and a name for the row component
/// </summary>
/// <param name="parentDataFlowTask"></param>
/// <param name="componentName"></param>
public ISMulticastComponent(ISDataFlowTask parentDataFlowTask, string componentName) :
base(parentDataFlowTask, "Microsoft.Multicast", componentName)
{
_numberOfInputsAllowed = 1;
_numberOfOutputsAllowed = -1;
}
/// <summary>
/// ctor that accepts the parent data flow task and a name for the row component
/// </summary>
/// <param name="parentDataFlowTask"></param>
/// <param name="componentName"></param>
public ISRowCountComponent(ISDataFlowTask parentDataFlowTask, string componentName) :
base(parentDataFlowTask, "Microsoft.RowCount", componentName)
{
_numberOfInputsAllowed = 1;
_numberOfOutputsAllowed = 1;
}
public ISDestinationComponent(ISDataFlowTask parentDataFlowTask, string componentMoniker, string componentname)
: base(parentDataFlowTask, componentMoniker, componentname)
{
}
public ISAdoNetDestinationComponent(ISDataFlowTask parentDataFlowTask, string componentname) :
base(parentDataFlowTask, "Microsoft.SqlServer.Dts.Pipeline.ADONETDestination, Microsoft.SqlServer.ADONETDest, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91", componentname)
{
//InitDefaults();
ExternalColumnInputColumnMap = new List <ExternalColumnInputMap>();
}
public ISPipelineComponent(ISDataFlowTask parentDataFlowTask, string componentMoniker, string componentname) :
this(componentname, componentMoniker, parentDataFlowTask.MainPipe)
{
ParentDataFlowTask = parentDataFlowTask;
}
public ISSourceComponent(ISDataFlowTask parentDataFlowTask, string componentMoniker, string componentname)
: base(parentDataFlowTask, componentMoniker, componentname)
{
}