This is a 3-container project that performs an ETL job for the file example.csv that is included. I divide this service into 3 containers to conserve separation of concern as much as possible. The ...

Load a csv data file into an MS SQL Server database with a dynamically generated table based on the csv header columns and data values using a powershell script. This script generates the table and ...

I have a daily generated csv file that I'm going to have its contents inserted into tables in our SQL Server database. I can open the csv as a recordset in ADO, but I'm not sure how I open a second ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...