question

ShivamRamola-8222 avatar image
0 Votes"
ShivamRamola-8222 asked SathyamoorthyVijayakumar-MSFT commented

Capture Set variable Output in a file

I have used 2 variables with array data type to store the values of a database table name
the first variable is pointing to set variable and the other one is pointing to append variable.
Now these value needed to be stored in file in storage account

Could you please guide on how to store these values in a file.

azure-data-factoryazure-monitorazure-data-lake-storage
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ShivamRamola-8222 ,
Just checking in to see if the below answer provided by @NandanHegde-7720 helped. 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.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered NandanHegde-7720 commented
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your answer.
I have gone through this but is there a way to put the data in a csv file.

0 Votes 0 ·

Hey,
Instead of JSON dataset, you need to select delimited dataset. Thats the only change in sink.

Please accept it as answer in case if it resolved your query as it may benefit other community members as well.

Thanks

1 Vote 1 ·