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
henro.smit
SSC Veteran
Points: 244
More actions
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.