Best way to extract CLOB datatype from oracle to SQL db using SSIS 2005


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.

more ▼

asked Feb 23, 2010 at 02:35 PM in Default

avatar image

2 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Have you tried SSMA from MS?

Good link below


more ▼

answered Feb 23, 2010 at 05:57 PM

avatar image

10.8k 27 37 37

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 23, 2010 at 02:35 PM

Seen: 4479 times

Last Updated: Feb 23, 2010 at 02:35 PM

Copyright 2018 Redgate Software. Privacy Policy