Hexadecimal flat files

Occasional Visitor

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

4 Replies

@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

 

Hi
Thanks for the questions. The text file has hexadecimal characters.  I don’t have any tables yet.  
 
I usually use SAS so that am not familiar with SQL server terms. In SAS I just infile the file and apply formats. Right now I am trying to do the same with SQL but worry about decimals and end of file characters. 
Sharon
Still to less informations about the source file format & content.

Olaf

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