I am using SQL SERVER 2008 SP1. My ssis package is running fine if I ran it manually using BIDS but when I am trying to set up a job using Agent account but facing the following error:
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed. Source: Started: 11:40:22 AM Finished: 11:40:43 AM
Elapsed: 21.015 seconds. The package could not be loaded. The step failed.
I checked agent has full rights and I my ssis package are stored in SQL Server.
Any help would be appreciate.
Přesunutýamber zhang8. března 2012 6:16 (From:SQL Server Security)
When you call a package from a SQL Server Agent job step and the package doesn’t run, one of the following conditions is true:
The user account that runs the package as a job step differs from the original package author.—or—The user account does not have the required permissions to make connections or to access resources outside the package
I hope that helps you to diagnose the cause of the problem.