Cannot find file format binary

Hi OlaN ,

You can adjust the data type of the columns in the table to binary in the mapping step, but the binary type is not supported for file format.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Assuming you're using the Copy Data assistant to set the copy up, you'd need to select the source as a binary to be able to output the file as a binary.  (Binary doesn't try to decode the data).

If you try to replicate just using a Copy data activity, you'll find a variant of this error saying that if the destination is binary, then the source must be binary.

In short;  If you try to parse the file, you have to specific the output type - it can't be binary.