none
Import BLOB data from Oracle to SQL Server 2008

    Question

  • We are migrating a Oracle database to SQL Server 2008. But are having issues importing a table that has BLOB datatype in Oracle.

    Can someone help me on "how to convert or import BLOB data to SQLServer from Oracle"?

    Thanks,

    Varad

    Thursday, July 29, 2010 11:48 PM

Answers

  • Hello,

    Use SQL Server Integration Services (SSIS) to create a SSIS package and import that data. Try using the .NET Framework Data Provider for Oracle on the SSIS package to get connected to the Oracle database.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, July 30, 2010 3:00 AM
    Moderator