I will import automation of your csv or xlsx files into sql server
SQL Server data automation expert!
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
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 files other than CSV files?
Yes, CSV (comma-separated values) are a very common form of flat file. (*.csv), but Tab-delimited or other less common delimiters are also possible. Since everything is metadata-driven, it is possible to define your delimiting character (comma, tab, sem-colon, etc) just by changing the metadata.
Can you import Excel (xlsx) files?
Importing an Excel file is not the same as importing a CSV file. Excel files need a special driver installed that can read the xlsx format. The Microsoft documentation to install this driver is not intuitive. In fact, if you try and install the driver it will likely fail unless you trick it.
2 reviews for this Gig
| (2) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
M mcphillips72
Repeat Client

Australia
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
M 
Seller's Response
Helpful?E esten3333

United States
Exceptional work with MS SQL project.
$1,000-$1,500
Price
3 days
Duration
M 
Seller's Response
Helpful?
2 reviews for this Gig
| (2) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
M mcphillips72
Repeat Client

Australia
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
M 
Seller's Response
Helpful?E esten3333

United States
Exceptional work with MS SQL project.
$1,000-$1,500
Price
3 days
Duration
M 
Seller's Response
Helpful?

