Home Forums SQL Server 2008 SQL Server 2008 - General Loading DB2 CLOB data into SQL Server 2008 R2 SP1 RE: Loading DB2 CLOB data into SQL Server 2008 R2 SP1

  • June 1, 2012 at 7:28 am

    #1495845

    Thanks for your post. It was indeed a driver issue.

    The correct driver to use is the DB2 OLEDB/.Net provider with the datatype set to NTEXT.

    It also is much faster than using OPENQUERY with a linked server to Db2.