Login time out expiry when running SSIS package through agent job

Question

Hi ,

I get the following error when i try to schedule my ssis package. Its failing when i tries to process anything above 4000 records from a flat file source. Anything below 4000 and it processes fine.

Any suggestion would be very helpful.

Thanks ,

Abhi

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: Onl... The package execution fa... The step failed.

I am not using any remote connections.

Any ideas