ssis package for oracle source
how can i create the package for oracle source and sql server destination?with datatype conversion give me one example.
May 28th, 2012 6:00am

hi, I don't have experience of processing Oracle to SQL Server, I guess this problem I will meet someday. So I list some articles here hope it can help you and help me in the future. Oracle Source to SQL Server - http://blogs.msdn.com/b/sqlperf/archive/2009/08/14/using-ssis-to-get-data-out-of-oracle-a-big-surprise.aspx https://forums.oracle.com/forums/thread.jspa?messageID=10141352 For data type mapping, here's the mapping information between SQL Server and Oracle. http://docs.oracle.com/html/B10544_01/apa.htm And SSIS Data Types http://msdn.microsoft.com/en-us/library/ms141036.aspx Vote if it's helpful. Hope it helps. Simon
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2012 6:26am

At a minimum you need to load the Oracle client (32 bit to work in bids) You can load both the 32 and 64 bit clients on the same machine. Then if you are using SQL Enterprise version then you will want to download the Microsoft Attunity Oracle controls, they work much better than the Oledb method of accessing Oracle.Chuck Pedretti | Magenic North Region | magenic.com
May 28th, 2012 8:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics