SQL 2008 SSIS password saving - blanks

[David_1969]

Hi

Environment:
SQL 2008 version : Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) - Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (VM)
PGNP-1.3.0.2154
Postgress PostgreSQL 8.3.5 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2.20071124 (Red Hat 4.1.2-42)

Two connections:
1. Postgress Native OLE DB\PostgresSQL native Provider
2. Native OLE DB\ SQL Server native Client 10.0

I've set up a fairly simple development test between postgress and SQL server, it loads one OLE DB Source (Postgress)of a table into a SOLE DB Destinantion (SQL Server) the jobs work correctly in debug in the VS BIDS designer, when I save to MSDB and schedule I get the error below:

SSIS 2008 Error:
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "Cannot open DB connection.". An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x00000000 Description: "fe_sendauth: no password supplied ". End Error :

Am I doing anything incorrectly?, can the connection retain the password in MSDB?

Regards
David

[David_1969]

Changed how datasource is used so that it is now used as a connection manager opposed to data source and connection manager, security Encrypt sensitive with password save then reimport to MSDB works fine

[Moderator]

Looks like it is a package issue. I glad you found the solution and gave us update. Thank you!