locked
Support of binary SQL columns RRS feed

  • Question

  • Whenever I try to copy data from a SQL column of type binary to e.g. a blob-store, I get the following error:

    Data Type Binary is not supported. Detailed Message: ErrorCode=DataTypeNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column: Password,The data type Binary is not supported.,Source=,'

    according to this documentation https://azure.microsoft.com/en-us/documentation/articles/data-factory-azure-sql-data-warehouse-connector/#specifying-structure-definition-for-rectangular-datasets ADF supports binary which should be mapped to byte[]

    I was thinking that this is related to the CSV-file I export the data to which might not support byte[]?
    However, the error message explicitly states "Binary is not supported" which is a SQL datatype ?!?

    am I doing something wrong or is this simply not supported?

    thanks,
    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Friday, August 19, 2016 6:23 AM

All replies

  • Hi Gerhard,

    The mapped byte[] type is supported when Copy from SQL to Blob with Text format. I'm wondering whether you specify the "Binary" type in the structure? If that is the case, please specify as "Byte[]" instead.

    Let me know if you still have such issue, and please provide the runId for our further investigation.

    Wednesday, August 24, 2016 8:48 AM