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