I will develop your etl solution for microsoft sql server

Vetted Pro

United States

81 orders completed

SQL Server data automation expert!

I'm a career Microsoft SQL Server developer with over 25 years of full time database engineering experience (going back to SQL 6.5). I spent the last 21 years at the Microsoft mothership in Redmond, W...
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

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