hi,
There're 11 subpackages in a main package.Every subpackage will first delete
( by executing a store procedure) sql server data and
then transform data from INFORMIX to SQL SERVER.
I use both DTSRUN /F .. and DTS /S ... to run the package and get an error,
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 (80004005): Insert
error,line 104 ('tp_lmdm',DBTYPE_DBTIMESTAMP)¡AStatus 6:data exceed..¡C)
(Microsoft OLE DB Provider for SQL Server(80004005): Conversion invalid for
datatypes on column ....)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

My box is 4 Xeon CPU , 8G RAM , win2003 , sql 2000 sp3, mdac 2.8 , informix
ODBC csdk 2.81 TC1 and
the DTS maximum number of tasks executed in parallel is 2.
Based on the same source data(Informix),if I run each subpackage seperately
or reduce the executed number to 1,
both works great.
Really have no idea now...

TIA

steffi,

To debug load the data into a dummy table with all fields declared as
varchar and see what is wrong with the data. Most likely it is ODBC driver
parallel execution issue. Contact the driver vendor.

Ilya

"steffi" <steffibev (AT) hotmail (DOT) com> wrote