connection manager and password

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

connection manager and password

Author

Topic

jung1975
Aged Yak Warrior

503 Posts

Posted - 2007-08-13 : 11:03:57

In connection manager in ssis, I am able to choose 'Microsoft OLE DB Provider for Oralce' and
provide server name, username/ password. The test connection results is successful. and I check 'Save Password', however, when I try to run the package it keep getting an error:

ora-01017 - invalid username/ password.

it seem si can not save the pasword.. what should i do to resolve this problem

dsnider
Starting Member

4 Posts

Posted - 2007-08-23 : 16:06:48

Open up the Project you saved
Go to Package Tree
Connection Managers
Source Connections
----Properties Tab
Under Name
You should see the Password option

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources