In SSIS, using OLE DB Source and OLE DB Destination Task, moving the Table Data from One Table to Another Table (In Oracle DB). It is working fine. But it is taking 20 mins to transfer the 5300 records. Is this is a normal behaviour of SSIS Or is there is any tunning is required ? Using Oracle DB Linked server the same is done at 10 mins. Kindly explain in detail.Sridhar

The problem is that SSIS doesn't support bulk load into Oracle natively. So it is inserting the rows row by row, which is painfully slow. Try to download the Attunity providers for Oracle, they are much much faster.MCTS, MCITP - Please mark posts as answered where appropriate.

Hi Koen, Thanks for your reply. As you mentioned I searched for Attunity providers through some sites but i did't get the downloadable form. Can you help on this ?Sridhar

http://www.microsoft.com/en-us/download/search.aspx?q=attunity http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx

Sure. I had to do some searching myself, because most download links appear to be dead. http://www.microsoft.com/en-us/download/details.aspx?id=29283 I do hope you have enterprise edition, because they don't work on standard edition.MCTS, MCITP - Please mark posts as answered where appropriate.

Attunity oracle connector is the way to go. I have a query getting data from Oracle and used to take 3 hours. after using Attunity it only takes 25 minutes.

Koen Verbeeck, Thanks for your information. I am able to download but 2.0 version is not working properly. So from the link given by John Ang I got the 1.2 version it is working fine. Thanks for you both. I will try to execute the Package and let me see the result and execution time. Sridhar

Koen Verbeeck, Thanks for your information. I am able to download but 2.0 version is not working properly. So from the link given by John Ang I got the 1.2 version it is working fine. Thanks for you both. Sridhar Ah yes, I realized too late that version 2.0 is for SQL Server 2012, while 1.2 is for SQL Server 2008(R2).MCTS, MCITP - Please mark posts as answered where appropriate.

Koen, I am using 2008 not R2 version. This 1.2 version is compatible with 2008.Sridhar

Yes, that's why I put brackets around R2. Too lazy to type both versions :)MCTS, MCITP - Please mark posts as answered where appropriate.