Forum Discussion

Sharon_hurley's avatar
Sharon_hurley
Copper Contributor
Apr 12, 2022

Hexadecimal flat files

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 worr...
Sharon_Hurley850's avatar
Sharon_Hurley850
Copper Contributor
Apr 13, 2022

 

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
olafhelper's avatar
olafhelper
Bronze Contributor
Apr 14, 2022
Still to less informations about the source file format & content.

Olaf
  • Sharon_Hurley850's avatar
    Sharon_Hurley850
    Copper Contributor
    Apr 14, 2022

    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

Resources