August 6, 2004 at 3:02 am
Hi guys, Just trying to schedule a simple DTS task to copy data from one server to another server, when executed manually it works with no problems - however if scheduled keep getting this error : "Executed as user: SWPHQ-HDESKDB\SYSTEM. ...: Drop table [hdesk].[dbo].[HDESKJOBS] Step DTSRun OnFinish: Drop table [hdesk].[dbo].[HDESKJOBS] Step DTSRun OnStart: Create Table [hdesk].[dbo].[HDESKJOBS] Step DTSRun OnFinish: Create Table [hdesk].[dbo].[HDESKJOBS] Step DTSRun OnStart: Copy Data from _TELMASTE_ to [hdesk].[dbo].[HDESKJOBS] Step DTSRun OnError: Copy Data from _TELMASTE_ to [hdesk].[dbo].[HDESKJOBS] Step, Error = -2147220472 (80040408) Error string: The Data Pump Task requires Transformations to be specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error Detail Records: Error: -2147220472 (80040408); Provider Error: 0 (0) Error string: The Data Pump Task requires Transformations to be specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 DT... Process Exit Code 1. The step failed." Any ideas ??
Note the owner of the DTS has full domainadmin privs.
[font="Verdana"]Justin Hostettler-Davies[/font]
www.databaseexpertise.com
August 7, 2004 at 10:15 am
What tasks do you have listed in your package? Do you have multiple versions of the package created (i.e., have you changed/saved it multiple times)? If you have multiple versions of the package, have you deleted and recreated the job by right clicking on the package and choosing "Schedule Package..."? Recreating the job might help with this. Have you verified that the account running the SQL Agent Service has the same rights as the account used to "create" the package?
August 9, 2004 at 1:49 am
Yes, I have tried deleting & rescheduling the job.
The job users two servers - connects to one to copy data to another. The DTS package works on one of the servers but not the other - so surely it must be a rights issue ?
[font="Verdana"]Justin Hostettler-Davies[/font]
www.databaseexpertise.com
August 9, 2004 at 8:48 am
Is your SQL server service account in the windows Administrators group? by that I mean the log on account on the SQLSERVERAGENT service.
August 9, 2004 at 9:12 am
Yes the SQLSERVERAGENT service IS in the Admin group.
[font="Verdana"]Justin Hostettler-Davies[/font]
www.databaseexpertise.com
August 9, 2004 at 3:06 pm
Which server are you trying to schedule the package on? Source or destination?
Greg
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply