Auto import csv files into SQL Management Studio database

Question

We need to generate reports based on SQL queries that use multiple csv files(tables) in SQL Management Studio. This task will have to be done weekly with updated info.

We are looking for some method where we can place updated csv flat files in a folder skipping the step of having to import the tables weekly. The csv file names and data structure will not change from week to week.

If there is a way to do this or is there an alternate program or process that you would recommend ?

Answer 1

You can create an SSIS package to loop the folder to import data from csv files to the database tables. After the package is created, you can create an SQL job and schedule to run the job weekly.

Answer 2

Hi @Cartoonjazz ,

Just add some information based on GuoxiongYuan's reply.

Here is a detailed blog about loop through Flat Files in SQL Server Integration Services for your reference.

And then you may schedule the job to do this week to week.

sql-server-agent-jobs-for-packages

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October