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

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have you been into the task itself to make sure everything that should be hooked up IS hooked up. There are some discussions around this problem here

http://groups.google.com/groups?sourceid=ie7&rls=com.microsoft:en-US&ie=UTF-8&oe=UTF-8&q=%22One%20or%20more%20destination%20parameter%22%20and%20dts&sa=N&tab=wg

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"mecn" <mecn2002@xxxxxxxxx> wrote in message news:etsg1aYOHHA.536@xxxxxxxxxxxxxxxxxxxx:

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

.

Relevant Pages

  • 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 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)