Oracle export to SQL 2005 via SSIS, discard the previous unfinished message -
11-18-2005
, 08:28 AM
Hello All,
I export tables (about 50 of them) from Oracle 9 (using oledb) to sql2005.
My souce connection oledb to oracle contains a password. I have admin right
on sql2005.
When I open my SSIS in visual i have this message:
An OLE DB error has occured. Error code: 0x8004005. An OLE DB record is
available. SOurce: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005:
null password given; logon denied".
But the properties of my Oracle oledb connections clearly shows a password.
Where did I forget to mention a password?
For information, when i run the ssis the sql script of tables works fine but
not the content of the tables get transfered.
Thanks for your help |