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 |
|
thebruins
Starting Member
31 Posts |
 Posted - 2005-06-24 : 10:54:44
|
| I'm new to DTS packages, but have managed to create a package that reads data from a delimited textfile into a table. The package contains 4 activex scripts for 4 columns, the rest is 1:1-mapping from textfile to table.As customers will be supplying the textfiles in the near future, I want to do some error checking to make sure the data in the table remains reliable.Is there a way to tell the package which lines in the textfile to skip? For example, I'd like to skip the line if it's empty, or when the first field in the delimited data is empty or not long enough.Thanks... |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2005-06-24 : 15:32:15
|
| Load the data to a staging table and then use SQL to validate and copy the good rows. |
 |
|
|
|
|
|
error checking