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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-14 : 08:13:01
|
| Rakesh writes "Folks,I am currently working on two issues any / all help would be greatly appreciated.I am running a DTS package to export some data from SQLServer(local machine)to ORACLE(remote location). It works fine when the number of records are less than 300,000, but fails on anything over that. Some times it fails even for less than 200,000 records, so its random. I get the " insert failed on 222000 row number" (row number vaires at all times)So, to over come that I had started exporting records in the incrementals of 100,000 at each time, by doing the following from the DTS package itself by 1. setting the rowcount =100,000, execute DTS2. come back to query analyzer and set rowcount = 100,000 3. delete 100,000 records . 4. run steps 1-3 until all records are inserted.I am sure there should be a better way. :)But at the end of the process. The oracle totals are not matching although the number of records match in both the databases. Is there something going in the DTS package internallythat's messing up my data. ?? please let me know any info on this.Question # 2 .I connected to Oracle using the linked server, the questionis 1.how do I insert data using the Openquery method, syntax would do. 2.how do I execute a SQL Stored procedure using linked server (which picks data from SQL server and inserts into the target Oracle table.Please do let me know.Thanks,Rakesh." |
|
|
|
|
|
|
|
DTS failure & Linked server to Oracle