RE: SQL job fails running DTS -2147220482 (800403FE)

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have you check the credential of the SQL job? As to which account the SQL job
is run as? And if that account still have the needed permission?

"Goran Djuranovic" wrote:

Hi all,
I have a SQL job that runs the DTS package, which (simplified) consists of
loading some data fom another SQL server (linked) into an XML file and
saving it to the disk. After working fine for about a year, I suddenly
started getting these error messages:

Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string:
Error Code: 0 Error Source= msxml4.dll Error Description: Access is
denied. Error on Line 24 Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 4500 Error: -2147467259 (80004005); Provider Error:
0 (0) Error string: Access is denied. Error source:
msxml4.dll

I can run the DTS manually with success, but cannot manually nor
automatically run the SQL job. It fails with the same error.

TIA
Goran Djuranovic



.

Relevant Pages

  • Re: SQL job owner and right
    ... I just confirmed that we only have SQLAgentUserRole. ... and account A also has these three roles. ... What's the best practice to archive -- multiple accounts can manage SQL job ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • File Permissions for BCP job
    ... You have to make sure that the SQLServerAgent Service is ... change the owner to this account) to run as the same user. ... On the other file server, ... >server to BCP running as a SQL job on another SQL server ...
    (microsoft.public.sqlserver.security)
  • SQL job fails running DTS -2147220482 (800403FE)
    ... I have a SQL job that runs the DTS package, ... loading some data fom another SQL server into an XML file and ... Transformation Services (DTS) Package Help file: ... automatically run the SQL job. ...
    (microsoft.public.sqlserver.programming)
  • Re: Job/Sheduled DTS/...: Rename a File
    ... Execute a batch file either using DTS or sql job. ... SQL Server MVP ... "DraguVaso" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Error Handling
    ... Please provide any thoughts on handling DTS error while called from a SQL ... My SQL Job starts a DTS using dtsrun utility and when the DTS fails, ...
    (microsoft.public.sqlserver.server)