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...
brain246
Apr 16, 2023Copper Contributor
You just have to cut out the .csv in the expression above. Could just do it with a replace function. Don't use mapping data flows in that case, that would be a total overkill. Also, you might want to look at the standard metadata-driven copy flow in the templates library.