When deploying a SSIS package from pre-production to production system I get a message “The AcquireConnection method call failed with error code 0xC0202009.”
SSIS package "S:\Database\Backup\OneDrive\SSIS\TestImport\LoadCLient.dtsx" starting.
Information: 0x4004300A at Load Clients form main_db, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0202009 at Package: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Intellisoft OLE DB Provider for PostgreSQL" Hresult: 0x80004005 Description: "Cannot open DB connection.".
An OLE DB record is available. Source: "Intellisoft OLE DB Provider for PostgreSQL" Hresult: 0x00000000 Description: "fe_sendauth: no password supplied
".
Error: 0xC020801C at Load Clients form main_db, Источник "OLE DB" [2]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "XXX.XXX.XXX.XXX.main_db.main_user" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Load Clients form main_db, SSIS.Pipeline: Источник "OLE DB" failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Load Clients form main_db, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Load Clients form main_db: There were errors during task validation.
SSIS package "S:\Database\Backup\OneDrive\SSIS\TestImport\LoadCLient.dtsx" finished: Failure.
Программа "[8972] DtsDebugHost.exe: DTS" завершилась с кодом 0 (0x0).
What could be the problem?
