Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2010-08-31 : 05:54:28
|
| Hi,I have scheduled ssis jobs for daily run.In the middle of the run, after some two hours of run, the package gets failed and the job monitor shows the following error:Unable to complete login process due to delay in login responseWhat could be the possible reason for the failure?Please help me in solving this issue.Thanks.Varalakshmi. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-31 : 09:58:41
|
| are you able to log in to the resource in question? sounds like a server not responding...what is the package trying to login to? |
 |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2010-09-02 : 04:23:48
|
| The package runs for about two hours after which it is getting failed. The package is scheduled for Daily run and the error does not occur at every run. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-02 : 13:25:40
|
| are you able to manually log in to the resource in question?what is the package trying to login to?see anything in the event logs? |
|
|
|
|
|
|
Scheduled job failure