SQL 2008 SSIS password saving - blanks

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

SQL 2008 SSIS password saving - blanks

Postby David_1969 » Thu May 20, 2010 2:17 am

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
 
Posts: 2
Joined: Thu May 20, 2010 1:50 am

Re: SQL 2008 SSIS password saving - blanks

Postby David_1969 » Thu May 20, 2010 3:28 am

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
David_1969
 
Posts: 2
Joined: Thu May 20, 2010 1:50 am

Re: SQL 2008 SSIS password saving - blanks

Postby Moderator » Thu May 20, 2010 10:54 am

Looks like it is a package issue. I glad you found the solution and gave us update. Thank you!
User avatar
Moderator
Site Admin
 
Posts: 310
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 2 guests