Failure during copy from blob to sql db using ADF

Copper Contributor

Aug 03, 2017

Hello,
3days ago, I was able to copy data from BLOB CSV to SQL Database by Azure Data Factory COPY PREVIEW without any errors. I tried to do the same datas and process again today and got the same error message with you. It's so simple schema and less data. I think we had better send a support ticket to MS, because we couldn't get the next action from this message...
In addition, ADF COPY from SQL Database to SQL DWH was successful today.

The following is the error messge I got from ADF

----
Failed execution

Database operation failed. Error message from database execution : ExecuteNonQuery requires an open and available Connection. The connection's current state is closed..

LESS

Run ID

ce48e8c3-3c5d-4e3e-b841-9b8d5a6abc12_636370560000000000_636371424000000000_OutputDataset-55f

Data read: 1.25 MB
Data written: 380.38 KB
Rows: 6920
-----------------

regards,

Shigeru Numaguchi

Forum Discussion

Failure during copy from blob to sql db using ADF

Resources