How to resolve SSIS Package Error "Login timeout expired"

0

I am loading & executing the SSIS package in Windows service and setting the necessary SSIS package parameters (Including connection string for OLEDB Connection Manager) from win service.

My SSIS package is reading the CSV file from one of directory of server and parsing it and inserting the data in staging database.

Everything was working fine with this algorithm. but from couple of days, I am getting the following error from SSIS package while processing CSV file:

Error message: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Invalid connection string attribute". SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Database Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Import the data in table "{tablename}" failed the pre-execute phase and returned error code 0xC020801C.

But when I try to re-process csv file after few time, then it is processing through SSIS without throwing any SSIS package error. I have tried every solutions found via googling. Even if I have tried to set the ConnectionString of OLEDB Conecction Manager inside the SSIS.

Didn't working any solutions for me at this moments. Can anyone help me out?

Help would be more appreciated.

I have tried every solutions found via googling. Even if I have tried to set ConnectionString of OLEDB Conecction Manager inside the SSIS.

sql-server
csv
ssis
oledb
etl
asked on Stack Overflow Aug 9, 2019 by Ashish Bhalodiya • edited Aug 9, 2019 by Yahfoufi

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0