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 - 2002-01-31 : 00:11:19
|
| gyans writes "We are converting an Oracle database into SQL server 2000.The utility to import data seems to timeout every time, so I have to write a script to import data from excel spreadsheet into the SQL SERVER databases.I am new to SQL Server , I would like to know step by step how can I do this.Someone has already started the process and I have to finish it.Is it possible to write a stored procedure by declaring a cursorto do the select and inserts row by row.Thank you for your help.gyans" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-31 : 01:40:24
|
| Increase your Server's Query-Time out Setting and use DTS .Follow this link on how to to set your Query-Time Out setting.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12321HTH--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-01-31 : 01:41:54
|
| How big are your tables in Oracle? I import half a mill records from Oracle into SQL Server every day without issue. Are you using Data Transformation Services? If not, you should be. You'll need to install Oracle client on the PC you'll be doing the install from.(Go to the DTS folder in SQL Server,Local Packages and create new Package. You can just drop in an Oracle Data source, an SQL Server datasink, and then draw a transformation between them.)--I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 01/31/2002 01:42:43 |
|
|
|
|
|
|
import script