Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to know the failed record

Author  Topic 

vasu4us
Posting Yak Master

102 Posts

Posted - 2008-06-19 : 15:20:00
Hi all,I have a query with multiple joins in sql 2005 it runs for 4 hours in SSIS to load table in oracle. Its failing after loading 90% (around 6 million records). with error " Source: "OraOLEDB" Hresult: 0x80004005 Description: "ROW-00060: Internal error: [dainsert,16]"

I guess there is some unicode/non unicode issue in oneof the result set. How can i find the record? any help appriciated.

Thanks

   

- Advertisement -