question

apple avatar image
apple asked

Oracle to sql

Hi! i have package which is used for moving data from oracle to sql database.Right now it is very slow I need some suggestions to improve the performance. It uses OLEDB connection for oracle for connecting to oracle database. Thanks a lot
ssisoracle
10 |1200

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

1 Answer

·
SirSQL avatar image
SirSQL answered
I heartily recommend downloading the Attunity connector for Oracle (it's free). It could well make an enormous difference. [Documentation][1] [Download][2] [1]: http://msdn.microsoft.com/en-us/library/ee470675(v=SQL.100).aspx [2]: http://www.microsoft.com/en-us/download/details.aspx?id=29284
10 |1200

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.