January 31, 2005 at 10:42 am
SQL Server Agent reports the following error when attempting to run a DTS package:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Permission denied: 'CreateObject'
Error on Line 7
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500
Any thoughts on this would be appreciated.
Thanks.
January 31, 2005 at 11:22 pm
How are you running the scheduled job? Using the SQL scheduler? I assume that the job runs ok when you are logged on and run it. I always run my scheduled DTS packages using the windows scheduler program. This allows me to say which account to use when running. When you run the job using SQL job scheduler it runs using the account that sql server uses for the service (usually the system account). This account doesn't always have the rights it needs. Especially if not everything is on that server...
Michael
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply