x

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

Hi,

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

user
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

http://www.microsoft.com/sqlserver/2005/en/us/Migration-oracle.aspx

more ▼

answered Feb 23, 2010 at 05:57 PM

avatar image

sp_lock
10.7k 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x2022
x1198

asked: Feb 23, 2010 at 02:35 PM

Seen: 4307 times

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

Copyright 2017 Redgate Software. Privacy Policy