Groups | Blog | Home
all groups > sql server (microsoft) > december 2006 >

sql server (microsoft) : Problems getting data from an Oracle view to SQLSVR 2005 via SSIS any ideas?


hapedad
12/23/2006 7:58:30 AM
When using SSIS and importing data from a view in ORACLE, the
transformation does not pick up the precision on calculated columns
from the Oracle view. The calculated columns in the view have precision

applied to them via the CAST function. The data retrieved always comes

back as a NUMERIC(38). I am using the Microsoft for Oracle OLE DB
driver.
Any thoughts on how I can get the precision from the view through SSIS?
Jonathan Roberts
12/23/2006 11:33:53 AM
[quoted text, click to view]

Have you tried installing the Oracle client and using its ODBC driver?
AddThis Social Bookmark Button