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?
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.