July 9, 2007 at 9:10 am
I am attempting to execute a SQL Job (unscheduled DTS Package) from query analyzer using the sp_start_job approach.
When I run this package from EM - it works fine. When I attempt to run this as a job in Query Anayzer I receive the following error in the Job History:
Executed as user: CILSQL1\sa. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Copy Data from tmpTblDump to tmpTblDump Step DTSRun OnError: Copy Data from tmpTblDump to tmpTblDump Step, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 DTSRun OnFinish: Copy Data from tmpTblDump to tmpTblDump Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
As you have already guessed, this has to work via Query Analyzer. Can someone help? Thanks!
July 10, 2007 at 8:00 pm
Change the job step to use DTSrun utility to execute the DTS package.
Refer Link http://msdn2.microsoft.com/En-US/library/aa224467(SQL.80).aspx
I think this would help you.
Regards..Vidhya Sagar
SQL-Articles
July 11, 2007 at 3:57 am
Change the job to run under the agetn service account instead of sa account and see if that succeeds
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply