dbTalk Databases Forums  

Problem with DTS Transform step

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Problem with DTS Transform step in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dorian
 
Posts: n/a

Default Problem with DTS Transform step - 04-26-2010 , 05:48 PM






I'm getting "The Data Pump Task requires Transformations to be specified"
error.

The package has everything specified correctly. The package was created on
our dev server and then copied to our test server (to which I have NO update
access).
I was able to go into the package on the test server and test each data
transformation and they all worked. However, when our network guys run the
package, it fails.
The transform step copies from a text file to a database table which is
created in an earlier DTS step.
Any ideas? I've read every forum post I could find (here and elsewhere). All
I could find is vague references to problems when a package is created on one
server and run on another.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.