SQL 2008 SSIS password saving - blanks

  • David_1969
  • Topic Author
  • Visitor
  • Visitor
12 years 2 months ago #267 by David_1969
SQL 2008 SSIS password saving - blanks was created by 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

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

  • David_1969
  • Topic Author
  • Visitor
  • Visitor
12 years 2 months ago #268 by David_1969
Replied by David_1969 on topic Re: SQL 2008 SSIS password saving - blanks
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

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

More
12 years 2 months ago #271 by Moderator
Looks like it is a package issue. I glad you found the solution and gave us update. Thank you!

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

Time to create page: 0.063 seconds
Powered by Kunena Forum