August 21, 2012 at 10:32 am
Hi DBAs
My DTS package loads one table (2.5 million rows) data from Oracle in 1 hour.
as we are migrating from dts to ssis, the newly developed ssis package in sql server 2008r2 (pre-production box in testing phase)is taking 4 hours to load the same data from same source.
Can someone help/suggest me in improving the performance.
Thanks,
August 21, 2012 at 11:12 am
How are you getting data out of Oracle? Obviously it's a data flow task, but how is the data extracted? In other words, TSQL query, stored procedure, something else?
August 21, 2012 at 12:47 pm
I am pulling the data with query
August 21, 2012 at 2:12 pm
any changes to the way you connect to Oracle...eg linked server odbc drivers / 32/64bit etc?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 21, 2012 at 2:20 pm
Sqlism (8/21/2012)
I am pulling the data with query
Any optimizations you can add to the query? Can you post the TSQL here? It's going to be pretty tough to get at since we don't know the underlying structure of the Oracle data being pulled.
Also I think someone mentioned the connection type. Did you change the driver you're using to connect to Oracle?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply