A target worker has at least one input port, but no data output ports. It consumes the input data rows, and typically loads them to an external target, such as a database, a file, a .NET collection etc.
- The library user instantiates targets via factory methods, see Worker Instantiation for details
- The type parameters describe what ports the transform has, e.g.
*Error*means it has an error output port
Func callback once, which consumes rows from the upstream worker.
Execute an SQL query for each incoming row.
Inserts incoming rows into an SQL table or view.
High performance bulk insert of incoming records into a SQL Server table or non-partitioned view using SqlBulkCopy.
Consume incoming rows from the upstream worker and add them to an ICollection<T>.
- Factory: CollectionTargetFactory
Consume incoming rows from the upstream worker and add them to an IDictionary<TKey,TValue>.
Pass rows from a child worker input port to a parent worker output port. Used when encapsulating dataflow workers inside parent dataflow workers.
Func callback for each input row.
Func callback when there are rows to consume from the upstream worker.
Execute a virtual method when there are input rows available. Must be inherited.
Execute a virtual method for each input row. Must be inherited.
- Worker: RowTargetBase<TInput>
Execute a virtual method for each input row. Has an
ErrorOutput port. Must be inherited.
A worker with one input for deriving dataflow targets. Must be inherited.
Consume and discard all incoming rows.
Writes incoming rows to an XLSX spreadsheet file. Does not require any driver installation. Also see EPPlus XLSX Files.