Search code examples
ssisbinaryetlraw-file

Reading a binary file with SSIS

We have a binary file (from a telecom system). Can SSIS read it?

From what I have read about Raw File Source, it can only read files created by Raw File Destination. Is that correct?

Solution

  • The answer at this time is that SSIS cannot read a binary file that is not formatted in the same way as a file produced by Raw File Destination.

    You could use create a Custom SSIS Component Class and register it for use in SSIS.
    Developing a Custom SSIS Source Component Not for the faint of heart.

    Another way would be to write a program to convert the binary file into a file that can be read by SSIS or load the output into a database table. So much for what SSIS can do for you.