question

user avatar image
user asked

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.

sql-server-2005ssis
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered

Have you tried SSMA from MS?

Good link below

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.