Class DbDestination<TInput>

A database destination represents a table where data from the flow is inserted. Inserts are done in batches (using Bulk insert or an equivalent).

Inheritance
System.Object
GenericTask
DataFlowTask
DataFlowDestination<TInput[]>
DataFlowBatchDestination<TInput>
DbDestination<TInput>
DbDestination
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.DataFlow.Connectors
Assembly: ETLBox.dll
Syntax
public class DbDestination<TInput> : DataFlowBatchDestination<TInput>, IDataFlowDestination<TInput[]>, IDataFlowLinkTarget<TInput[]>, IDataFlowBatchDestination<TInput>, IDataFlowDestination<TInput>, IDataFlowLinkTarget<TInput>, ITask
Type Parameters
Name Description
TInput

Data type for input, preferably representing the destination table.

Constructors

DbDestination()

Declaration
public DbDestination()

DbDestination(IConnectionManager)

Declaration
public DbDestination(IConnectionManager connectionManager)
Parameters
Type Name Description
IConnectionManager connectionManager

DbDestination(IConnectionManager, String)

Declaration
public DbDestination(IConnectionManager connectionManager, string tableName)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String tableName

DbDestination(IConnectionManager, String, Int32)

Declaration
public DbDestination(IConnectionManager connectionManager, string tableName, int batchSize)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String tableName
System.Int32 batchSize

DbDestination(Int32)

Declaration
public DbDestination(int batchSize)
Parameters
Type Name Description
System.Int32 batchSize

DbDestination(String)

Declaration
public DbDestination(string tableName)
Parameters
Type Name Description
System.String tableName

DbDestination(String, Int32)

Declaration
public DbDestination(string tableName, int batchSize)
Parameters
Type Name Description
System.String tableName
System.Int32 batchSize

Properties

BulkInsertConnectionManager

Declaration
public IConnectionManager BulkInsertConnectionManager { get; set; }
Property Value
Type Description
IConnectionManager

DestinationTableDefinition

If you don't want ETLBox to dynamically read the destination table definition from the database, you can provide your own table definition.

Declaration
public TableDefinition DestinationTableDefinition { get; set; }
Property Value
Type Description
TableDefinition

TableName

Name of the target table that receives the data from the data flow.

Declaration
public string TableName { get; set; }
Property Value
Type Description
System.String

TaskName

Declaration
public override string TaskName { get; }
Property Value
Type Description
System.String
Overrides

Methods

FinishWrite()

Declaration
protected override void FinishWrite()
Overrides
ETLBox.DataFlow.DataFlowBatchDestination<TInput>.FinishWrite()

InitObjects(Int32)

Declaration
protected override void InitObjects(int batchSize)
Parameters
Type Name Description
System.Int32 batchSize
Overrides
ETLBox.DataFlow.DataFlowBatchDestination<TInput>.InitObjects(System.Int32)

PrepareWrite()

Declaration
protected override void PrepareWrite()
Overrides
ETLBox.DataFlow.DataFlowBatchDestination<TInput>.PrepareWrite()

TryBulkInsertData(TInput[])

Declaration
protected override void TryBulkInsertData(TInput[] data)
Parameters
Type Name Description
TInput[] data
Overrides
ETLBox.DataFlow.DataFlowBatchDestination<TInput>.TryBulkInsertData(TInput[])

Implements