load files into sql server

arkiboys 9,536 Reputation points
2020-11-24T08:32:10.813+00:00

Hello,
I come from the ssis background where I am able to load .csv files one at a time into sql server...
Can you please point me to video or a step by step lab/documentation where it sows me how to load .csv files one at a time in a loop into say azure sql server and move the files into appropriate folder once processed....?

Thank you

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,591 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,448 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,891 Reputation points
    2020-11-25T09:56:51.29+00:00

    Hi @arkiboys ,

    May I know if these csv files have same structures?

    If yes, please refer to the following link:

    Loop through Flat Files in SQL Server Integration Services

    Best Regards,
    Mona

    ----------

    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 in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?

    1 person found this answer helpful.