No. of failing rows exceed the max. specified (urgent)

Posted by Rickeybglr under Sql Server on 10/4/2011 | Points: 10 | Views : 1165 | Status : [Member] | Replies : 1
while runnig tranformation package on sql server 05, i got this error TransformationCopy conversion error conversion invalid for datatype on column pair 1 ......(column names)
No. of failing rows exceed the maximum specified. i read somewhere tht set max error count to 999 would be the solution for ths error. but still getting error.

this transformation is reading data from 2 txt files and according to tht update the tables.
i hava a dts of 2 txt file. i need to run both the file at a time.
Plz advise on same ...
thanks in advance


Posted by: Rickeybglr on: 10/13/2011 [Member] Starter | Points: 25

please answer ths post

Rickeybglr, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response