I have to move huge volume of xml data stored as CLOB from oracle to SQL using SSIS 2005. im not able to use ole db source as it says the datatype is not supported, but if i use data redaer source it takes hours to move the data to destination. Please suggest a way to do this more efficiently, and i do not have the option to use ssis 2008 attunity also.
asked Feb 23, 2010 at 02:35 PM in Default
Have you tried SSMA from MS?
Good link below
answered Feb 23, 2010 at 05:57 PM