Error code 0xC0202009 when deploying a SSIS package

  • Dmitro Babko
  • Topic Author
  • Offline
  • User
  • User
More
1 year 1 month ago #14774 by Dmitro Babko
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?

 

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #14776 by admin
Most likely there is a missing/wrong connection string parameter. Please collect trace in PGNProfiler in order to see additional details about reason of the issue (launch as Admin and click button in toolbar to start capture).

Please Log in or Create an account to join the conversation.

Time to create page: 0.160 seconds
Powered by Kunena Forum