import multiple CSV files

How to Build a Job to Import Multiple CSV files into a SQL Server Database

Have you ever faced the necessity to load data from multiple CSV files into multiple database tables? Not so uncommon, right? In this article, we share a step-by-step tutorial on how to perform an automatic bulk insert from the CSV files. The script examples are provided too.