Hi,

I am trying to import a text file using dts package into sql server. While running i get the error as following.


Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (8004202c): TransformCopy 'Transform Store Nbr' conversion error: General conversion failure on column pair 1 (source column 'Store Nbr' (DBTYPE_STR), destination column 'Store Nbr' (DBTYPE_NUMERIC)).)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Any suggestion is most welcome. Thanks in advance.

*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....fc0617ad1f3636
*****************************************

If data rows are to big, try to use bulk insert , it is fast and efficent.

"Srinivas via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote