CODEWITHSUNDEEP
sql-serverssisetloledbexception
C-El
C-El

Reputation: 1

SSIS Job Execution Issue: Connection Errors and Read-Only Database

I've set up a job in SQL Server that needs to be executed daily. This job involves an SSIS package, which retrieves Excel files from a directory on another server and populates tables in a database. Unfortunately, the job is failing with the following error:

Source error failed validation and returned error 0xC020801C SSIS Error Code DTS_E_CONNATACQUIRECONNECTIONFROMCONNECTIONMANAGER.\ The AcquireConnection method call to the connection manager "source excel" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
SSIS Error Code DTS_E_OLEDBERROR. STG_DIM An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft Access Database Engine' Hresult: 0x80004005. Description: *Mise à jour impossible. La base de données ou l'objet est en lecture seule.

When I execute the packages from the Integration Server catalog, there is no issue. However, this problem only occurs when the job runs.

My connection to the SQL Server is through Windows authentication.

Upvotes: 0

Views: 136

Answers (0)

Related Questions