Unanswered: SQL Server 2005 Import and Export + ORA-01017
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.