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 |
|
Vijay
Starting Member
8 Posts |
 Posted - 2003-01-22 : 10:24:58
|
| I have a simple DTS package that imports data from a Pipe (“|”) delimited text file. The text file is fairly structured and has fixed number of fields. It so happened that one out 300,000 records had one additional field. The DTS package fails in such a scenario. Is there a way to skip the fields that exceed the max number of columns? Thanks in advance for your time. |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-22 : 11:06:16
|
| I've not used DTS in quite a while but can you not create a ON FAILURE pathway that with the aid of a bit of code writes the offending record to an ERROR table for later scrutiny ?===========Paul |
 |
|
|
|
|
|
Skipping invalid rows in DTS Package