ETLBox 2.1.3

A lightweight ETL (extract, transform, load) library and data integration toolbox for .NET. Source and destination components let you read and write data from the most common databases and file types. Transformations allow you to you harmonize, filter, aggregate, validate and clean your data.

Install-Package ETLBox -Version 2.1.3

dotnet add package ETLBox --version 2.1.3

<PackageReference Include="ETLBox" Version="2.1.3" />

paket add ETLBox --version 2.1.3

Release Notes

What's new in 2.1.X? The whole linking, task and exception handling of data flow components was improved. Also the whole interface of the data flow and control flow classes has been refined. As these changes are mostly hidden, it was necessary to prepare the new features that will be introduced with 2.1.x and later versions.

Version 2.1.3 offers smaller improvements and bugfixes: In CustomSource, the ReadCompletedFunc was changed to ReadingCompleted and is now a Predicate<T>. The Aggregation now accepts a list of AggregateColumns/GroupColumns objects, which also works with ExpandoObjects. ColumnRename now takes a list of ColumnMap objects instead a string list. Also, ColumnRename now has a RemoveColumns property where property names can be added that are supposed to be removed. DbDestination now accepts a list of ColumnMap objects to map property names to column names - this also works with dynamic objects. The Aggregation now comes with First/LastValue aggregation methods. The DbMerge now has a fix for handling multiple id columns and possible key collision, and also can now handle null values in the Id columns.

Dependencies

• .NETStandard 2.0

  • Microsoft.CSharp (>= 4.7.0)
  • Newtonsoft.Json (>= 12.0.3)
  • NLog.Extensions.Logging (>= 1.6.4)
  • System.Data.Common (>= 4.3.0)
  • System.Threading.Tasks.Dataflow (>= 4.11.1)
  • TSQL.Parser (>= 1.5.2)

Used By

Version History