SQL Query in CSV File in blob storage

Question

SQL Query in CSV File in blob storage

Rohit Kulkarni 731

Hello Team,

I am having 3 queries in sql server . I need to run all the 3 queries and need to copy the data into 3 different files into Azure blob storage.(FiileName1,FileName2,FileName3) please advise me how it can be done.

Regards
Rohit

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2022-02-01T16:12:04.543+00:00

Hello @Rohit Kulkarni ,

Just wanted to understand whether the answer by @Nandan Hegde . If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

1 answer

Your answer

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2022-02-01T16:12:04.543+00:00

Hello @Rohit Kulkarni ,

Just wanted to understand whether the answer by @Nandan Hegde . If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

Hey,
There can be multiple ways:

Easy way would be to create 3 different copy activities with each query mapping to each file
other way would be to create a config/parameter value with the queries and its corresponding file name and using foreach activity (3 iterations) and one copy activity with source query value parameterized as item().Query and filename as item().filename, you can have 3 diff files one per query

Share via

SQL Query in CSV File in blob storage

1 answer

Your answer