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 - 2001-12-16 : 11:54:38
|
| Daniel writes "I'm trying to insert the contents of a CSV file into a SS7 database. The data is quite messy and often generates errors when inserting. The data is from a third party and cannot be cleaned economically.Is it possible to skip records with errors and continue processing the CSV file?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2001-12-17 : 12:01:27
|
| On the advanced tab of a transformation in DTS there is a Max Error Count Option. You can set this as high as 9,999 and kick the bad records to an exception file. Other than that you probably be best off pre-processing the file like Merkin suggested. Just a quick field validation that creates a load and an excepiton file... should be pretty easy to generate.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
Resume INSERT following error