October 5, 2011 at 2:06 am
Hi All
An SSIS package I created yesterday via the maintenance plan wizard failed last night with the below error message.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
The job is set to run as the agent account which has SA access, could it be that SSIS is trying to log in as the SSIS service account before it then switches to the agent account?
Thanks
Ant
October 5, 2011 at 4:50 am
The error you are getting is happening when SQL Agent is trying to open the package. The server that it is attempting to connect to may be incorrect. Another possible reason may be that SSIS on that server is incorrectly configured.
Can you connect to SSIS (using Management Studio) on the server that SQL Agent is trying to load the package from? If you can, are you able to see the package ?
October 5, 2011 at 4:59 am
Yeah I can connect to the SSIS via SSMS and the SSIS package is there, the SSIS package was created by the maintenance plan wizard, it only rebuilds a few indexes as well as a couple of other new business functions.
October 6, 2011 at 5:44 am
Next - in the job that is running the package, is the server name correct ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply