Forum Discussion
Copy activity: Disable staging?
Hi, i try to copy data from warehouse (view) to warehouse (table). Is there a way to disable staging? I get the validation error "Direct copying data to Data Warehouse using Copy command is not s...
Probably my answer arrived a bit late. I have faced the same problem and the copy activity takes ages to complete.
My solution was to write a stored procedure that performs first a truncate and then the insert into table statement. I have inserted 220M of rows in 3 minutes using this method.
hey there, having the same issue, how did you accomplish the stored procedure method?
