November 24, 2010 at 1:42 pm
Transferring 2 million records from SQL server to Oracle using simple OLE DB Source and Destination in SSIS.
The package hangs in yellow showing 7000 rows passed to destiantion, nothin happens for hours, next day I came in and saw 70000 records processed and still in yellow.
Today the same thing is happening. It works(2 million records processed in 40 secs) when I change the destination to SQL Server. I am guessing its something to do with the Oracle destination. I am really new to oracle environment.
So what can I do? is it something I have change in SSIS pakcage or the destination itself. If you guys need more info about this. please ask. Thanks
November 24, 2010 at 1:46 pm
What kind of connection are you using to connect to the Oracle instance?
Have you installed any Oracle drivers?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 24, 2010 at 3:18 pm
I am using the OLE db provider for Oracle that comes with SSIS.
I saw a post about using Oracle attinuity tool or something. I am really not sure if I have to go that way.
November 25, 2010 at 2:31 am
I came accross this link yesterday when I was looking for a solution to running out of vitual memory when using import column transformation. I think it may solve your problem too
Thanks
November 28, 2010 at 3:12 pm
The attinuity connectors for Oracle did the job, got million records in less than a minute.
Thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply