I will develop your etl solution for microsoft sql server
Vetted by Fiverr Pro
Adrian was selected by the Fiverr Pro team for their expertise.
Vetted for
Databases
About this Gig
Vetted Pro
Dynamic ETL (Extract Transform and Load)
If you need to load flat files, usually CSV (.csv = comma-separated values) or tab-delimited values (like an Excel file) this is the solution for you.
I have evolved, enhanced, improved, and optimized this code design over the last 20 years.
My dynamic, metadata-driven design works with any table schema and almost every datatype.
I will load flat file data from your hard drive into your Microsoft SQL Server.
I use my own proprietary logic that utilizes a common set of dynamic stored procedures, functions, and views that rely on internal metadata to load an unlimited number of flat files into an unlimited number of tables, all using one set of generic logic.
- No need to develop individual processes for different file structures.
- No need to build SSIS (SQL Server Integration Services) packages to load the files.
- No need to purchase expensive third-party software to accomplish your ETL tasks.
This solution also includes custom business rules to handle data-specific data handling rules and is smart enough to know what has been imported and what flat files are new.
Please contact me for custom pricing as your scenario is unique.
Database type:
Relational database
Platform:
MS SQL
•
SQL Server
Expertise:
SQL
•
DDL
•
DML
•
Other
Clients I’ve worked with
Microsoft
High-Tech Company
I was a SQL Server Consultant for Microsoft. I developed SQL Server database solutions for Microsoft and their customers. I was a Principal Program Manager with the SQL Server Product Group (my org developed SQL Server and Azure SQL Database)
Feb 2013-Aug 2019
My Portfolio
Other Databases Services I Offer
FAQ
Will this solution work on other database platforms besides Microsoft SQL Server?
No, this database solution only works on Microsoft SQL Server. I do not support MySQL, Oracle, PostgreSQL, or other relational database platforms.
Can this solution import any type of flat file?
Technically "No". However, the most common types of flat files are CSV (comma-separated values), tab-delimited files, or fixed-width character-based files. My generic solution will not import images, or binary data, however, I can import ANY type of data, but it may not fit in a relational database.

