Apr 12 2022 11:29 AM
Hi
i need to import large hexidecimal flat files into one table in the sql server with a line having up to 2000 characters. The record does not need to be broken up yet.
Any suggestions? I’m worried about carriage returns for starters.
Sharon
Apr 12 2022 10:24 PM
@Sharon_hurley , sorry, but for me it is not clear what your requirements are nor what you try to achieve here?
What's a hexdecimal file, an unusally term?
A binary file like an image?
Or a text file with hexadecimal representation of numbers?
And how does the target table look like (DDL statement)?
Olaf
Apr 13 2022 06:58 AM
Apr 14 2022 12:47 AM
Apr 14 2022 06:21 AM
Hi
Thanks again for your reply. We receive the file from a large company using an interface built by COBOL. The file contains hexadecimal characters.
Sharon