The company I'm currentyl emplyed with is migrating their data from an Oracle driven environment to an MSSQL2000 environment.
the problem I'm facing is that some Oracle DB fields are binary.
If I write a DTS package to import the data from Oracle into MSSQL all goes well, but MSSQL displays this data simply as <binary>.
Is there a way to transform that data into it's original value while exporting/importing ?
Any help would be greatly appreciated !