DTS error--Microsoft Data Transformation Services (DTS) Data Pump -- sql server dts

mecn
1/16/2007 10:55:12 AM

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

Allan Mitchell
1/16/2007 9:18:34 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : DTS error--Microsoft Data Transformation Services (DTS) Data Pump