Hello All,

I'm trying to load data into a table in SQL Server 2005 schema from Oracle schema using DTSWizard.

Following is the details:

Source: Oracle 10g
Destination: MS SQL Server 2005
Data Source: Microsoft OLE DB Provider for Oracle

I have given all the details correctly in Data Link Properties window (Datasource, User, Password) and I got "Test Connection Succeeded" message when I clicked on "Test Connection" Button.
I left the two check boxes blank, Blank Password and Allow Saving Password, and proceeded further and I get the following error
ORA-01017: invalid username/password; logon denied (Microsoft OLE DB Provider for Oracle). However, When I check the Allow Saving Password box, I could load the data succesfully.

Can any one help me in knowing the exact reason for this behaviour.
Your help is greatly appreciated.

Thanks in advance,