January 2, 2002 at 1:47 pm
This came out of a job I scheduled. Any ideas what could be causing these errors?
Thanks for your help!
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147213242 (80042046)
Error string: General error -2147213242 (80042046).
Error source: Microsoft Data Transformation Services (DTS) Data Pump
Help file: sqldts.hlp
Help context: 0
Error Detail Records:
Error: -2147213242 (80042046); Provider Error: 0 (0)
Error string: General error -2147213242 (80042046).
Error source: Microsoft Data Transformation Services (DTS) Data Pump
Help file: sqldts.hlp
Help context: 0
Error: -2147213242 (80042046); Provider Error: 0 (0)
Error string: ActiveX Scripting Transform 'DTSTransformation__5' was not able to initialize the script execution engine.
Error source: Microsoft Data Transformation Services (DTS) Data Pump
Help file: sqldts.hlp
Help context: 30601
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
January 2, 2002 at 2:40 pm
Can you run it manually? If so, then it is probably a permissions issue.
Rob DeMotsis
Sr. SQL Server DBA
Pier 1 Imports, Inc.
Rob DeMotsis
Sr. SQL Server DBA
January 3, 2002 at 8:34 am
Rob,
I can execute the package, but when I schedule the package to run the job fails. The owner of the job is 'sa'. Any ideas?
Thanks!
January 3, 2002 at 8:59 am
It does indeed sound like a permissions issue. As if the account that the SQL Server Agent is running under can't execute whatever comprises your scripting engine...
Does the SQL Server Agent service account have equal or greater privileges than your user account?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 3, 2002 at 10:05 am
Also, what does the job do? Use network resources? connect to another SQL Server?
I agree with Brian.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply