I will import automation of your csv or xlsx files into sql server

Vetted Pro

4.8
4.8

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 (ETL = Extract Transform and Load)

Do you have a directory full of CSV or Excel files that need to be loaded into a Microsoft SQL Server Database?

I will deliver a dynamic database solution that will use intelligent design functionality to load your CSV or XLSX files into a database.

(.csv = comma-separated values)

There are potentially many ways to load flat files into a database, I use my own proprietary automation logic that utilizes a common set of dynamic procedures, functions, and views that rely on internal metadata to load an unlimited number of CSV files into an unlimited number of tables.


  • 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.


Watch my demo video to see how easy it can be to import and process your files.


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 CSV files are new.


Please contact me for custom pricing as every customer's requirements are different.

Database type:

Relational database

Platform:

MS SQL

SQL Server

Expertise:

Data warehouse

SQL

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

Reviews

2 reviews for this Gig
4.8

(2)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    4.5
Sort By
Most relevant
  • M

    mcphillips72

    Repeat Client

    AU

    Australia

    5

    Working with Adrian was an EXCEPTIONAL experience! His professionalism and attention to detail in the database project truly exceeded expectations. His proactive communication and quick delivery made the process smooth and enjoyable. Highly recommend! 👏

    $50-$100

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • E

    esten3333

    US

    United States

    4.7

    Exceptional work with MS SQL project.

    $1,000-$1,500

    Price

    3 days

    Duration

    Helpful?
    Yes
    No
Reviews

2 reviews for this Gig
4.8

(2)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    4.5
Sort By
Most relevant
  • M

    mcphillips72

    Repeat Client

    AU

    Australia

    5

    Working with Adrian was an EXCEPTIONAL experience! His professionalism and attention to detail in the database project truly exceeded expectations. His proactive communication and quick delivery made the process smooth and enjoyable. Highly recommend! 👏

    $50-$100

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • E

    esten3333

    US

    United States

    4.7

    Exceptional work with MS SQL project.

    $1,000-$1,500

    Price

    3 days

    Duration

    Helpful?
    Yes
    No