Error trying to copy data from Azure SQL database to Azure Blob Storage

Question

I have created a pipeline in Azure data factory (V1). I have a copy pipeline, that has an AzureSqlTable data set on input and AzureBlob data set as output. The AzureSqlTable data set that I use as input, is created as output of another pipeline. In this pipeline I launch a procedure that copies one table entry to blob csv file. I get the following error when launching pipeline:

Copy activity encountered a user error: ErrorCode=UserErrorTabularCopyBehaviorNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=CopyBehavior property is not supported if the source is tabular data source.,Source=Microsoft.DataTransfer.ClientLibrary,'.

How can I solve this?

Answer 1

So, actually, if we don't use this awful "Copy data (PREVIEW)" action and we actually add an activity to existing pipeline and not a new pipeline - everything works. So the solution is to add a copy activity manually into an existing pipeline.

Answer 2

According to the error information, it indicateds that it is not supported action for Azure data factory, but if use Azure sql table as input and Azure blob data as output it should be supported by Azure data factory.

I also do a demo test it with Azure portal. You also could follow the detail steps to do that.

1.Click the copy data from Azure portal.

2.Set copy properties.

3.Select the source

4.Select the destination data store

5.Complete the deployment

6.Check the result from azure and storage.

Update:

If we want to use the existing dataset we could choose [From Existing Conections], for more information please refer to the screenshot.

Update2:

For Data Factory(v1) copy activity settings it just supports to use existing Azure blob storage/Azure Data Lake Store Dataset. More detail information please refer to this link.

If using Data Factory(V2) is acceptable, we could using existing azure sql dataset.