SSIS and Connection Password

[Eddiecan]

Hi,

I have an SSIS package where it keeeps failing and give the following error message :

"System.Data.Odbc.OdbcException: ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) "

The step needs to connect to the Oracle database and run it's think. I type in the user and password and it never save it. Even if I check the "save password" it keeps loosing it ...

I added in the string, in the properties, the security is not at "encrypted ..."

What could be wrong ? What can I do to fix it ?

Any help will be appreciate.
Thanks
Ed

 

[MDXer]

you need to change the encryption level of your package or use configuration variables. if you set configuration variables it allows the packages to be transportable.

 

[Eddiecan]

Thanks for the info

I changed it to EncryptwithUserKey
and now I'm getting :

[Get Status Records [655]] Error: System.InvalidOperationException: Invalid operation. The connection is closed. at System.Data.OracleClient.OracleCommand.GetStatementHandle() at


I'm trying to connect my Oracle database, which I know it's working since I can connect to it using SQL+ and run queries and all ...

Any ideas why I'm getting this now ?

Thanks for your help

 

[MDXer]

not sure but usually some well worded google or live searches revial underlying problems such as this.