Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abacusdotcom
Posting Yak Master
133 Posts |
 Posted - 2011-07-19 : 04:35:55
|
| Dear All,I have been having sleepless night with this for more than 2 weeks. This also made me re-write codes many times.Am using Sql sever 2005 presently.I initially used SSIS to move data from ORACLE to SQL SERVER, record count slightly above 1 million rows. And runs for 4 hrs. But the whole process returns lesser rows. Do I have to tweak something in the process? Do I need to do something to destination? I even used linked server but still get the same output. What made matter worst is I always have varying record count at every 4 hours.Kindly help.I sign for fame not for shame but all the same, I sign my name. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-19 : 09:23:59
|
| 4 hours for a million rows?! Seems you have either blocking, network issues, or a whole lot of activity on one of the servers.How are you copying the data?Checked what else is happening on the servers at this time? |
 |
|
|
|
|
|
Incomplete Data during long ETL Process