When I create a package that loads data from oracle 11g to SQL Server 2008 R2 X64 by using the wizard it performs perfectly.
I then try to change the package in bids to use my shared data sources. no problem when changing source connection. But when i try to change the destination OLEDB then it starts to perform very badly.
I have tried running it with the from wizard defined destinationOLEDB and after changed in BIDS, there is a huge difference in performance.
Any idea why this happens?
I have even removed 64bit mode in debugging.
View Complete Post