SSIS null password given when executing package

Discussion:

(too old to reply)

mystical potato

2006-09-25 12:14:01 UTC

I created a package configuration and used the package installation wizard to
deploy a package to my dev server.

The package pulls data from Oracles servers (9.2 Oracle client and
ADO.NET:System.Data.OracleClient.OracleConnection objects to connect to the
servers. In the package configuration I added the passwords for the oracle
connection object and added the package to the server.

When I run the package that is now on the server from my machine it works
fine. If I remote into the machine and run the package it fails with the
follwing error:

Error: system.data.OracleClient.OracleException: ORA-01005: null password
given; logon denied...

Does anyone know why this is happening? thanks Scott

Charles Kangai

2006-09-27 12:36:02 UTC

Permalink

Is Oracle client installed on the server?

Hope this helps.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk

Post by mystical potato
I created a package configuration and used the package installation wizard to
deploy a package to my dev server.
The package pulls data from Oracles servers (9.2 Oracle client and
ADO.NET:System.Data.OracleClient.OracleConnection objects to connect to the
servers. In the package configuration I added the passwords for the oracle
connection object and added the package to the server.
When I run the package that is now on the server from my machine it works
fine. If I remote into the machine and run the package it fails with the
Error: system.data.OracleClient.OracleException: ORA-01005: null password
given; logon denied...
Does anyone know why this is happening? thanks Scott

mystical potato

2006-09-27 13:27:02 UTC

Permalink

Yes, Oracle 9.2 is running on the server. I have other packages running on
this server that hit 8.x servers. The server I'm having problems with is 10g.

However, I just figured out what the issue is. In an effort to test I was
trying different types of connections (e.g. Native OLE/DB Provider for
Oracle, .NET Providers\OracleClient Data Provider). Even though some of
these connections were not being used (and I didn't put them in the config
file), the sql server attempted to validate them and ended on error. I put
all the password info in all my connections objects and everything works fine.

The thing that throws me is why does the package fail if it is executed on
the server but run when I execute the same package (on the server) from my
local machine? Is the password info cached on my machine or something
similar???

thanks,
Scott

Post by Charles Kangai
Is Oracle client installed on the server?
Hope this helps.
Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk

Charles Kangai

2006-09-27 14:19:02 UTC

Permalink

It would fail if you are logging onto the server with an account that is
different than the account you are using on the other machine. The
ProtectionLevel property of the package may be set to
EncryptSensitiveWithUserKey. User Key is the Login credentials, and if these
are different, it cannot decrypt the password. Check the ProtectionLevel
property of the package in BIDS.

Hope this helps.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk

Post by mystical potato
Yes, Oracle 9.2 is running on the server. I have other packages running on
this server that hit 8.x servers. The server I'm having problems with is 10g.
However, I just figured out what the issue is. In an effort to test I was
trying different types of connections (e.g. Native OLE/DB Provider for
Oracle, .NET Providers\OracleClient Data Provider). Even though some of
these connections were not being used (and I didn't put them in the config
file), the sql server attempted to validate them and ended on error. I put
all the password info in all my connections objects and everything works fine.
The thing that throws me is why does the package fail if it is executed on
the server but run when I execute the same package (on the server) from my
local machine? Is the password info cached on my machine or something
similar???
thanks,
Scott

frank lee

2009-04-03 13:11:29 UTC

Permalink

Message
Executed as user: UMC-USERS\lish. ...ion 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:05 AM Error: 2009-04-03 08:00:06.58 Code: 0xC0047062 Source: Data Flow Task Source - Query [1] Description: System.Data.OracleClient.OracleException: ORA-01005: null password given; logon denied at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.Provide... The package execution fa... The step failed.

From http://www.google.com/search?hl=en&q=System.Data.OracleClient.OracleException:+ORA-01005:+null+password+given;+logon+denied+&btnG=Searc

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/