Forum Discussion
NImai1185
Dec 31, 2022Copper Contributor
Blob to Sql
Hello I am trying to copy my 3 CSV files from my blob to my SQL Database, with the help of metadata and for-each activity. I have my SQL tables created with proper schema and want to create a...
Gunjan_Kanani
Apr 08, 2023Copper Contributor
Hello NImai1185
If you want to copy your 3 files to its relevant tables, then simply use Data flow as create 3 data sets for your csv files and 3 for tables.
If not, then you have to store the table names in array variable and then replace those names with the file name and pass into the foreach activity and in sink parameter.
So, it will store files in its relevant tables.