I have followed your steps, pipeline is successful but no data is getting loaded. I have additional columns configured in source of copy activity. Only those columns are loaded, all other columns which are coming from source are not getting loaded.
So I did the same with on prem sql server to the warehouse , and checked every connections are preview working but when I am validating the activity I got this error "Copying data from on-premises connection with staging storage in workspace is not supported. Please use external staging storage instead." what could be the solution?
Thanks for sharing. Is it possible for you to share the data in the csv format so that we can load it either on the Azure Cloud or on-premise database?
Hi sir, can we use metadata activity instead of look up activity, in order to perform same operation and get same result? Is metadata activity can do the same work as look up activity do?
Nice one. Usefulefor me. Thx
I have followed your steps, pipeline is successful but no data is getting loaded. I have additional columns configured in source of copy activity. Only those columns are loaded, all other columns which are coming from source are not getting loaded.
So I did the same with on prem sql server to the warehouse , and checked every connections are preview working but when I am validating the activity I got this error
"Copying data from on-premises connection with staging storage in workspace is not supported. Please use external staging storage instead."
what could be the solution?
Thanks for sharing. Is it possible for you to share the data in the csv format so that we can load it either on the Azure Cloud or on-premise database?
Hi sir, can we use metadata activity instead of look up activity, in order to perform same operation and get same result?
Is metadata activity can do the same work as look up activity do?
No, you will not be able to write query inside the meta data activity.