Post reply

SQL Agent not able to execute package

  • April 9, 2009 at 5:29 am

    #202904

    Im sure this is a common proble.

    When I run the SSIS package manually it works finr, when I import it and schedule a SQL Agent job it fails.

    Error:

    32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:24:49 Could not load package "\AMS\Get RDIR file via FTP" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed. Source: Started: 12:24:49 Finished: 12:25:05 Elapsed: 15.657 seconds. The package could not be loaded. The step failed.

  • April 9, 2009 at 7:00 am

    #974998

    You need to set up a proxy account (mapped to a Credential) with permissions to SSIS sub system. Then run the job via the proxy account. This should solve your problem.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply