Insert new entries of csv into Sql automatically

Question

Hi Experts,

Please help me with following case:

I have an csv in which daily "new data" will gets append to old data via Power Automate, Now i want mssql automatically insert that "new data" into existing table of database

Answer 1

And what's the problem here?

You could e.g. create a SSIS package to import the data from CSV file.

Answer 2

Hi @Ganesh Babu Kondiboyina

You may use SSIS to load data from csv file to SQL Server database.

Check Import a CSV file into SQL Server with SSIS.

If you only want to add new data to the table, you may add Lookup Transformation in your package as said here.

In addition, you may schedule the package via sql agent job.

Deploy and Schedule an SQL Server Integration Services SSIS Package Step by Step

Regards，

Zoe Hui

---

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