SQL Server 2005 – How do I import data from an Ora | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server 2005 – How do I import data from an Ora

All, Subject: SQL Server 2005 – How do I import data from an Oracle Data Pump file? Tried looking in the SQL help for this and it’s not very forthcoming on how
you do this. How do I achieve this? Can someone send me an example SSIS package OR tell
me the steps OR point me towards a resource that could help me? Look forward to your replies. Many thanks,
Regards,
Richard.

Where did you looked, I believe there is a topic available in updated SQL 2005 books online such as HOW DO I topics. If this is a one-off requirement then you can take help of SSMA for Oracle,http://sqlug.be/blogs/por_dentro_sql/archive/2006/10/24/379.aspx fyi. Alsohttp://msdn2.microsoft.com/en-us/library/bb332055.aspx on more with topic . Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thank you for your help. I will read these articles and let you know how I get on. Regards,
Richard.
]]>