September 26, 2008 at 2:06 am
I have a DTS package which runs fine when I run it on schedule, i got error message :
DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220479 (80040401) Error string: Invalid Task Result value. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220479 (80040401); Provider Error: 0 (0) Error string: Invalid Task Result value. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp
but if i run it manualy, it's no prob. and either i run once time dts run with no prob, but if i run with schedule every day, i got this error,
please some body help me.
thx
September 29, 2008 at 12:28 pm
What does the Active X script task do?
It's most likely a permissions issue. When you run the package, it uses your login's permissions. When scheduled in a job, the package uses the permissions of the account the SQL Server Agent runs under.
Can you log on to the SQL server with the Agent's account and execute the package successfully? Probably not.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply