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 |
|
Suraci
Starting Member
1 Post |
 Posted - 2010-11-05 : 19:33:19
|
| Hello all, I'd like to import a large .html file up to the 4000th line or so into a Blob variable or something like that. After that, i'd like to hack it down to something smaller based on keyword finding. (file seems to large to load into regex anywhere else). Does anyone have any ideas? Thanks! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-06 : 10:31:54
|
| you could probably bulk insert into a varchar(max) column. That has a last line parameter to stop the import where you want to.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Large File Import up to certain line