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 |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2008-04-04 : 03:26:03
|
| HiI have approximatly 1 million rows to insert in a database from a csv file. When I do that using DTS I get a timout. What would be the best way to insert this huge amount without timeout? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-04 : 05:29:00
|
| 1 million doesn't seem to be a huge number for DTS. Where do you get timeout? in DTS?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2008-04-04 : 05:30:58
|
| Yes |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-04 : 05:40:19
|
| Try increasing your connection timeout setting for your connection object.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2008-04-04 : 07:00:42
|
| HiI inserted the rows now, but when I add a extra column named ID and set that to Identity, I get a timeout when Sql server change all rows. Is there anywhere I can change that timeout period? |
|
|
|
chorofonfilo
Starting Member
40 Posts |
Posted - 2008-04-04 : 10:48:55
|
quote:
Originally posted by magmo
HiI inserted the rows now, but when I add a extra column named ID and set that to Identity, I get a timeout when Sql server change all rows. Is there anywhere I can change that timeout period?
Hi, if you wanna increase the timeout value for your connection just use the enterprise manager to do so, open it, and right click on your sql server instance(the server icon) in which the database is contained, then choose properties, and choose the connections tag, in the bottom part of the window it says something like timeout value of the query, and then increase the value for it, accept and thats it.I hope this helped you.Perseverance worths it...:) |
|
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2008-04-04 : 13:22:08
|
| Excellent, thanks for the answer! |
|
|
|
chorofonfilo
Starting Member
40 Posts |
Posted - 2008-04-04 : 19:29:34
|
quote:
Originally posted by magmo
Excellent, thanks for the answer!
You are always welcome :).Perseverance worths it...:) |
|
|
|
|
|
|
|
|
huge amount of dts insert cause timeout