dbTalk Databases Forums  

Oracle export to SQL 2005 via SSIS, discard the previous unfinished message

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Oracle export to SQL 2005 via SSIS, discard the previous unfinished message in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wilfrid
 
Posts: n/a

Default 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.