Hi All

I am transferring from SServer TEXT(MAX) column to an Oracle CLOB destination using the attunity Oracle driver.

The package crashes when its about to write to the Oracle table. I have tried changing the source to NVARCHAR instead of TEXT but still the same problem.

The Error is "SSIS debug Host has stopped working". There are no more details.

I am on SSIS 2008R2

Any ideas? 

Thanx

Hi Paj,

CLOB AFAIK is not supported by Attunity in SSIS 2008. Please double-check with Attunity.

Hi Paj,

Have you checked the commercial COZYROC Oracle Destination component ? It supports CLOB and doesn't require SQL Server Enterprise Edition license.