ETLBox 2.5.2

.NET 5.0 This package targets .NET 5.0. The package is compatible with this framework or higher. .NET Core 3.1 This package targets .NET Core 3.1. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package ETLBox --version 2.5.2                

                    
                

            
NuGet\Install-Package ETLBox -Version 2.5.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="ETLBox" Version="2.5.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add ETLBox --version 2.5.2                

                    
                

            
#r "nuget: ETLBox, 2.5.2"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install ETLBox as a Cake Addin
#addin nuget:?package=ETLBox&version=2.5.2

// Install ETLBox as a Cake Tool
#tool nuget:?package=ETLBox&version=2.5.2

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.

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 is compatible. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 is compatible. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (32)

Showing the top 5 NuGet packages that depend on ETLBox:

Package Downloads
ETLBox.SqlServer

This is the SQL Server connector for ETLBox. It enables integration with Microsoft SQL Server for handling structured data in ETL workflows. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.Json

This is the JSON connector for ETLBox. It lets you handle structured and semi-structured JSON data, whether working with files or APIs. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.Postgres

This is the PostgreSQL connector for ETLBox. It supports reading from and writing to PostgreSQL databases for scalable data pipelines. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.Csv

This is the CSV connector for ETLBox. It helps you read and write data in CSV format, making it easy to handle flat-file data for import, export, and transformations. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.MySql

This is the MySQL connector for ETLBox. It lets you connect to MySQL databases, handling relational data for ETL tasks and integrations. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.7.0 1,806 3/7/2025
3.6.1 19,133 1/6/2025
3.5.2 3,658 12/20/2024
3.5.2-beta 84 12/10/2024
3.5.2-alpha 76 12/3/2024
3.5.1 913 11/15/2024
3.5.0 2,027 10/14/2024
3.4.4 849 9/30/2024
3.4.3 1,187 9/12/2024
3.4.2 1,064 9/3/2024
3.4.1 1,642 7/15/2024
3.4.0 2,882 5/29/2024
3.3.0 3,737 3/14/2024
3.2.0 11,229 1/11/2024
3.1.0 6,161 11/24/2023
3.0.2 15,196 10/6/2023
3.0.1 2,369 9/27/2023
3.0.0 6,431 7/11/2023
2.7.1 2,516 6/5/2023
2.7.0 5,118 4/4/2023
2.6.8 6,676 2/9/2023
2.6.7 4,679 1/9/2023
2.6.6 8,236 10/28/2022
2.6.5 6,970 10/19/2022
2.6.4 7,073 10/10/2022
2.6.3 7,112 9/26/2022
2.6.2 7,195 7/8/2022
2.6.1 7,607 5/19/2022
2.6.0 7,483 3/22/2022
2.5.2 7,362 12/30/2021
2.5.1 4,574 10/8/2021
2.5.0 8,256 9/27/2021
2.4.4 5,516 8/4/2021
2.4.3 4,286 7/16/2021
2.4.2 4,310 7/2/2021
2.4.1 9,397 5/17/2021
2.4.0 4,130 4/13/2021
2.3.2 1,765 3/2/2021
2.3.1 4,168 2/16/2021
2.3.0 5,389 1/11/2021
2.2.5 4,405 12/21/2020
2.2.4 3,692 12/15/2020
2.2.3 4,004 12/4/2020
2.2.1 1,589 11/23/2020
2.2.0 4,467 11/17/2020
2.1.4-beta 1,279 10/28/2020
2.1.4-alpha 784 10/24/2020
2.1.3 1,735 10/23/2020
2.1.2 5,495 9/24/2020
2.1.1 1,726 9/3/2020
2.1.0 3,893 9/3/2020
2.0.7 1,118 8/13/2020
2.0.6 1,180 8/13/2020
2.0.5 1,817 7/14/2020
2.0.4 1,613 7/9/2020
2.0.3 1,541 7/1/2020
2.0.2 3,975 7/1/2020
2.0.1 3,685 6/19/2020
2.0.0 3,220 6/10/2020
1.8.9 1,665 6/10/2020
1.8.8 1,494 5/27/2020
1.8.8-beta 1,096 5/24/2020
1.8.8-alpha 1,137 5/18/2020
1.8.7 17,248 5/12/2020
1.8.7-alpha 1,047 4/22/2020
1.8.6 4,037 4/21/2020
1.8.5 2,510 4/9/2020
1.8.4 1,363 4/6/2020
1.8.3 3,104 3/24/2020
1.8.2 1,379 3/9/2020
1.8.2-alpha 954 2/28/2020
1.8.1 2,633 2/27/2020
1.8.0 2,315 2/22/2020
1.8.0-rc2 956 2/15/2020
1.8.0-rc1 810 2/14/2020
1.8.0-beta 799 2/10/2020
1.8.0-alpha 888 2/4/2020
1.7.7 1,475 1/29/2020
1.7.6 1,286 1/15/2020
1.7.5 1,270 1/5/2020
1.7.5-alpha 842 1/3/2020
1.7.4 1,181 1/2/2020
1.7.4-alpha 816 12/31/2019
1.7.3 1,148 12/26/2019
1.7.2 1,154 12/16/2019
1.7.1 1,686 11/30/2019
1.7.0 984 11/25/2019
1.6.5 1,068 11/22/2019
1.6.4 1,030 11/17/2019
1.6.3 1,693 11/8/2019
1.6.2 1,055 11/4/2019
1.6.2-alpha 840 10/22/2019
1.6.1 1,391 10/18/2019
1.6.0 1,058 10/7/2019
1.5.0 1,135 9/13/2019
1.4.2 1,045 8/30/2019
1.4.1 966 8/27/2019
1.4.0 982 8/8/2019
1.3.2 959 8/5/2019
1.3.1 1,093 6/26/2019
1.3.0 1,066 6/6/2019
1.2.3 1,010 6/5/2019
1.2.2 1,114 5/24/2019
1.2.1 1,053 4/22/2019
1.2.0 1,110 4/13/2019
1.1.2 1,143 3/28/2019
1.1.1 1,450 2/2/2019
1.1.0 1,144 1/28/2019
1.1.0-beta 977 1/14/2019
1.0.1 1,236 12/20/2018
1.0.0 1,151 12/17/2018
0.1.1 1,275 12/10/2018

Features:
Streaming sources enhanced with RowModificationAction that allows to enrich rows with the current stream meta data or to modify rows before they are sent into the output buffer
LookupTransformation: Property IgnoreDataTypes renamed to UseExactNumericTypes
DbMerge supports duplicate filtering with the new flag 'FilterDuplicates'
TextDestination: Added WriteHeaderFunc which writes a custom header line as first row into output file
ColumnMap attribute extended with property "IgnoreColumn" which allows to ignore particular columns when reading or writing into a database

Bug fixes:
.NET 3.1 and .NET standard version contains references to 3.1 system packages, .NET 5  only references 5.0 system packages
DbMerge now ignores flawed rows (redirected via LinkErrorTo) in delta output
Improved exception handling for SqlTask.ExecuteReader
SqlServer: fixed bug when reading column definition from tables containing HIERACHYID, GEOGRAPHY or GEOMETRY data type
CreateTableTask: Fixed bug that prevented keywords to be used as default values
TableDefinition in SqlServer: Sql specific keywords in default values (e.g. GETDATE) are now correctly read
DbMerge: will throw exception if a readonly variable is used incorrectly as CompareColumn
DbSource/DbDestination/DbMerge: Improved exception message if a column mapping with duplicate column names is provided
Fixed bug when parsing sql statements that contained column names in single quotes
Using GetNextUri/HasNextUri, error message improved if status code response is not 200
Fixed in DbMerge: If input row is null, Exception is thrown: "TargetException: Non-static method requires a target"
Lookup: retrieved column values are now converted automatically into type of destination property