i have dts package that contains number of tasks. somewhere in DTS package i
m loading data from oracle to oracle. i have four data trasform tasks. three
data trasform tasks are running fine. but in data trasform task, i m getting
error: 'The number of failing rows exceeds the maximum specified' + Row -0060:
Internal error : [dainsert,16]e. can someone help in figuring out what this
kind of error it is?

Go to the properties of the Transform Data task. On the Options tab, uncheck
7.0 format, but check Error Text, Source Err Rows, Dest Err Rows and provide
a filename. Under Data Movement, change Max Error Count to something large,
e.g. 9999. This will allow you to capture the failed rows in files
<errorfilename>.source and <errorfilename>.dest. You can then examine the
rows to find out why they are failing.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk



"hiralkumar ghelani" wrote:

On sql server 2000 we solve this problem by an update of sql server

Nicolas Guinet

"hiralkumar ghelani" <u27443@uwe> a écrit dans le message de news:
6736f651d92ad (AT) uwe (DOT) ..

Can you explain me in little bit detail?
Nicolas Guinet wrote:
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200610/1