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 lightweight ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build Scalable Data Pipelines for SQL, NoSQL, APIs, and Flat Files # Automate Data Transformation, Validation, and Cleaning # Ideal for Data Warehousing, Migration, and Synchronization Simplify Data Integration and Automation: ETLBox provides source and destination components to read and write data from databases, APIs, and file formats like CSV, Excel, and JSON. Transformations let you harmonize, filter, aggregate, validate, and clean your data in parallel workflows. Key Features: * Supports streaming data pipelines for real-time processing * Parallel data flow processing for faster ETL pipelines * Extensive set of built-in connectors with support for custom extensions 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 lightweight ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build Scalable Data Pipelines for SQL, NoSQL, APIs, and Flat Files # Automate Data Transformation, Validation, and Cleaning # Ideal for Data Warehousing, Migration, and Synchronization Simplify Data Integration and Automation: ETLBox provides source and destination components to read and write data from databases, APIs, and file formats like CSV, Excel, and JSON. Transformations let you harmonize, filter, aggregate, validate, and clean your data in parallel workflows. Key Features: * Supports streaming data pipelines for real-time processing * Parallel data flow processing for faster ETL pipelines * Extensive set of built-in connectors with support for custom extensions 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 lightweight ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build Scalable Data Pipelines for SQL, NoSQL, APIs, and Flat Files # Automate Data Transformation, Validation, and Cleaning # Ideal for Data Warehousing, Migration, and Synchronization Simplify Data Integration and Automation: ETLBox provides source and destination components to read and write data from databases, APIs, and file formats like CSV, Excel, and JSON. Transformations let you harmonize, filter, aggregate, validate, and clean your data in parallel workflows. Key Features: * Supports streaming data pipelines for real-time processing * Parallel data flow processing for faster ETL pipelines * Extensive set of built-in connectors with support for custom extensions 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 lightweight ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build Scalable Data Pipelines for SQL, NoSQL, APIs, and Flat Files # Automate Data Transformation, Validation, and Cleaning # Ideal for Data Warehousing, Migration, and Synchronization Simplify Data Integration and Automation: ETLBox provides source and destination components to read and write data from databases, APIs, and file formats like CSV, Excel, and JSON. Transformations let you harmonize, filter, aggregate, validate, and clean your data in parallel workflows. Key Features: * Supports streaming data pipelines for real-time processing * Parallel data flow processing for faster ETL pipelines * Extensive set of built-in connectors with support for custom extensions 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 lightweight ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build Scalable Data Pipelines for SQL, NoSQL, APIs, and Flat Files # Automate Data Transformation, Validation, and Cleaning # Ideal for Data Warehousing, Migration, and Synchronization Simplify Data Integration and Automation: ETLBox provides source and destination components to read and write data from databases, APIs, and file formats like CSV, Excel, and JSON. Transformations let you harmonize, filter, aggregate, validate, and clean your data in parallel workflows. Key Features: * Supports streaming data pipelines for real-time processing * Parallel data flow processing for faster ETL pipelines * Extensive set of built-in connectors with support for custom extensions 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.6.1 3,874 1/6/2025
3.6.0 759 1/6/2025
3.5.2 3,651 12/20/2024
3.5.2-beta 77 12/10/2024
3.5.2-alpha 73 12/3/2024
3.5.1 887 11/15/2024
3.5.0 1,627 10/14/2024
3.4.4 846 9/30/2024
3.4.3 1,164 9/12/2024
3.4.2 1,063 9/3/2024
3.4.1 1,625 7/15/2024
3.4.0 2,706 5/29/2024
3.3.0 3,659 3/14/2024
3.2.0 10,561 1/11/2024
3.1.0 6,138 11/24/2023
3.0.2 13,409 10/6/2023
3.0.1 2,355 9/27/2023
3.0.0 6,281 7/11/2023
2.7.1 2,504 6/5/2023
2.7.0 5,112 4/4/2023
2.6.8 6,648 2/9/2023
2.6.7 4,668 1/9/2023
2.6.6 8,215 10/28/2022
2.6.5 6,964 10/19/2022
2.6.4 7,067 10/10/2022
2.6.3 7,105 9/26/2022
2.6.2 7,151 7/8/2022
2.6.1 7,599 5/19/2022
2.6.0 7,441 3/22/2022
2.5.2 7,265 12/30/2021
2.5.1 4,560 10/8/2021
2.5.0 8,241 9/27/2021
2.4.4 5,505 8/4/2021
2.4.3 4,278 7/16/2021
2.4.2 4,302 7/2/2021
2.4.1 9,364 5/17/2021
2.4.0 4,121 4/13/2021
2.3.2 1,734 3/2/2021
2.3.1 4,157 2/16/2021
2.3.0 5,345 1/11/2021
2.2.5 4,381 12/21/2020
2.2.4 3,682 12/15/2020
2.2.3 3,994 12/4/2020
2.2.1 1,579 11/23/2020
2.2.0 4,457 11/17/2020
2.1.4-beta 1,269 10/28/2020
2.1.4-alpha 774 10/24/2020
2.1.3 1,725 10/23/2020
2.1.2 5,481 9/24/2020
2.1.1 1,716 9/3/2020
2.1.0 3,884 9/3/2020
2.0.7 1,108 8/13/2020
2.0.6 1,170 8/13/2020
2.0.5 1,807 7/14/2020
2.0.4 1,603 7/9/2020
2.0.3 1,530 7/1/2020
2.0.2 3,946 7/1/2020
2.0.1 3,650 6/19/2020
2.0.0 3,209 6/10/2020
1.8.9 1,411 6/10/2020
1.8.8 1,240 5/27/2020
1.8.8-beta 838 5/24/2020
1.8.8-alpha 881 5/18/2020
1.8.7 16,991 5/12/2020
1.8.7-alpha 792 4/22/2020
1.8.6 3,752 4/21/2020
1.8.5 2,250 4/9/2020
1.8.4 1,104 4/6/2020
1.8.3 2,843 3/24/2020
1.8.2 1,367 3/9/2020
1.8.2-alpha 942 2/28/2020
1.8.1 2,621 2/27/2020
1.8.0 2,303 2/22/2020
1.8.0-rc2 944 2/15/2020
1.8.0-rc1 798 2/14/2020
1.8.0-beta 787 2/10/2020
1.8.0-alpha 876 2/4/2020
1.7.7 1,463 1/29/2020
1.7.6 1,274 1/15/2020
1.7.5 1,257 1/5/2020
1.7.5-alpha 830 1/3/2020
1.7.4 1,169 1/2/2020
1.7.4-alpha 798 12/31/2019
1.7.3 1,136 12/26/2019
1.7.2 1,141 12/16/2019
1.7.1 1,673 11/30/2019
1.7.0 971 11/25/2019
1.6.5 1,056 11/22/2019
1.6.4 1,017 11/17/2019
1.6.3 1,642 11/8/2019
1.6.2 1,042 11/4/2019
1.6.2-alpha 827 10/22/2019
1.6.1 1,378 10/18/2019
1.6.0 1,045 10/7/2019
1.5.0 1,121 9/13/2019
1.4.2 1,032 8/30/2019
1.4.1 953 8/27/2019
1.4.0 969 8/8/2019
1.3.2 944 8/5/2019
1.3.1 1,078 6/26/2019
1.3.0 1,053 6/6/2019
1.2.3 997 6/5/2019
1.2.2 1,101 5/24/2019
1.2.1 1,039 4/22/2019
1.2.0 1,094 4/13/2019
1.1.2 1,127 3/28/2019
1.1.1 1,434 2/2/2019
1.1.0 1,127 1/28/2019
1.1.0-beta 962 1/14/2019
1.0.1 1,221 12/20/2018
1.0.0 1,136 12/17/2018
0.1.1 1,257 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