How to store sql data of type VARBINARY


  • We are moving some of the existing data stored in SQL Server with one column as VARBINARY(MAX). I am aware of 4MB limit.

    We are Reading from SQL Server and copying to a file. It works fine but when we are trying to read the file back it is failing with error saying invalid characters.

    Any suggestions/solutions will be helpful.

    Wednesday, August 16, 2017 4:30 PM

All replies

  • I'd be happy to help.  Just to confirm, you're moving data from SQL Server to Azure Data Lake Store?  or just to Azure?


    Wednesday, August 16, 2017 6:22 PM