June 23, 2011 at 9:23 am
In total, about 10,000. There are some updates too, so that's why I was curious to see if there was a way to do it within SQL Server.
Mike Scalise, PMP
https://www.michaelscalise.com
June 23, 2011 at 9:32 am
10,000 rows... No way I'd be doing separate inserts via ODBC. I would explore alternate methods.
Push the rows over to thew remote server and then run a bulk load process of some sort. It will mean you will have to become more familiar with that Database Server but there is no other way.
The probability of survival is inversely proportional to the angle of arrival.
June 23, 2011 at 9:35 am
sturner (6/23/2011)
10,000 rows... No way I'd be doing separate inserts via ODBC. I would explore alternate methods.Push the rows over to thew remote server and then run a bulk load process of some sort. It will mean you will have to become more familiar with that Database Server but there is no other way.
Agreed. Seems the only way to make this not be like pulling teeth is to get it local to the server and bulk load it. ODBC is good at some things but 10,000 individual inserts across the wire is not on that list. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply