ETLBox 1.1.0

It's all in the box! Run all your ETL jobs with this awesome C# class library.

ETLBox is a comprehensive C# class library that is able to manage your whole ETL or ELT. You can use it to run some simple (or complex) sql against your database. You can easily manage your database using some easy-to-use and easy-to-understand objects. You can even create your own dataflow, where data is send from a source to a target and transformed on its way.

Install-Package ETLBox -Version 1.1.0

dotnet add package ETLBox --version 1.1.0

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

paket add ETLBox --version 1.1.0

Release Notes

DropDatabaseTask: static "convenience" method name changed from delete to drop ,ConnectionManager: (general) improved:verified that the underlying ADO.NET connection pooling is working (see Issue#1),
OdbcConnectionManager: ETLBox now supports connection via Odbc. (64bit only), AccessOdbcConnectionManager: ETLBox can now connect to access databases via ODBC (64bit ODBC driver required), DBSource: now accepts table name (instead of full table definition), ExcelSource: ETLBox can now read from excel files, CSVSource<CSVData>: Adding a generic implementation for the CSVSource, RowTransformation: Adding a non generic implementation (same as RowTansformation<string[],string[]>), DBDestination: Adding a non generic implemnetation. (same as DBDestination<string[]>)

Dependencies

• .NETCoreApp 2.1

  • CsvHelper (>= 12.1.1)
  • ExcelDataReader (>= 3.4.2)
  • Microsoft.SqlServer.SqlManagementObjects (>= 140.17283.0)
  • Newtonsoft.Json (>= 12.0.1)
  • NLog (>= 4.5.11)
  • NLog.Extensions.Logging (>= 1.4.0)
  • System.Data.Common (>= 4.3.0)
  • System.Data.Odbc (>= 4.5.0)
  • System.Data.SqlClient (>= 4.6.0)
  • System.Threading.Tasks.Dataflow (>= 4.9.0)
  • Unofficial.Microsoft.AnalysisServices.AdomdClientNetCore (>= 15.3.1)

Used By

Version History