Post reply

Problem With Scheduled DTS Package

  • January 31, 2005 at 10:42 am

    #109486

    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

    #539853

    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