DTS error--Microsoft Data Transformation Services (DTS) Data Pump

From: "mecn" <mecn2002@xxxxxxxxx>
Date: Tue, 16 Jan 2007 10:55:12 -0500

hi,

I saved a working dts package to a rest box and run it with the following
error,

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:DataDrivenQuery: One or more destination parameter
columns had no transform specified.
Step Error code: 80042066
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

thanks

.

Follow-Ups:
- Re: DTS error--Microsoft Data Transformation Services (DTS) Data Pump
  - From: Allan Mitchell

Prev by Date: Re: Slower performance in ActiveXscript task
Next by Date: Re: Slower performance in ActiveXscript task
Previous by thread: Slower performance in ActiveXscript task
Next by thread: Re: DTS error--Microsoft Data Transformation Services (DTS) Data Pump
Index(es):
- Date
- Thread

Relevant Pages

Re: DTS error--Microsoft Data Transformation Services (DTS) Data Pump
... I saved a working dts package to a rest box and run it with the following ... Microsoft Data Transformation Services Data Pump ... Step Error Description:DataDrivenQuery: One or more destination parameter ... Step Error Help File:sqldts80.hlp ...
(microsoft.public.sqlserver.dts)
Dts transformation error
... Microsoft Data Transformation Services Data Pump ... Integrity violation; attempt to insert NULL data or data which violates ... Error Help File:sqldts80.hlp ... Error Help Context ID:0 ...
(microsoft.public.sqlserver.dts)
Step Error code: 8004206A
... Microsoft Data Transformation Services Data Pump ... Step Error code: 8004206A ... Step Error Help File:sqldts80.hlp ... When I start the batch in the morning it sometimes runs with no problems en sometimes it fails. ...
(microsoft.public.sqlserver.dts)