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-04-12 : 08:50:59
|
| Paul Hirner writes "We are trying to import a 4.5 Million record file into SQL 2000. We keep getting an error_"cannot find selected row delimiter". Is there a way to find and exclude the bad record from the import." |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-12 : 09:27:56
|
| If you're using DTS to import the file, you can set the Max Error Count to allow SQL to run over a set number of bad records. See the 'Advanced' tab of the Data Transformation Properties dialog box. |
 |
|
|
|
|
|
Invalid Row delimiter preventing import to SQL 2000