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 worried about carriage returns for starters. 
Sharon

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 13, 2022

    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

    • 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

Resources