SQL 2008 SSIS password saving - blanks

More
10 years 2 months ago #267 by David_1969
David_1969 created the topic: SQL 2008 SSIS password saving - blanks
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.

More
10 years 2 months ago #268 by David_1969
David_1969 replied the 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
10 years 2 months ago #271 by Moderator
Moderator replied the topic: Re: SQL 2008 SSIS password saving - blanks
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.062 seconds
Powered by Kunena Forum