sql server programming: Hi,

I use DTS to import a text file into a table.
I have a primary key for this table.
If I have 3 lines to import in the text file, and if there is an error with
the on the line number 2 (because of the primary key field...), nothing is
imported.
I would like the DTS to import the lines 1 and 3, but i don't know how to do
this.

Many thanks,

Lionel H.

Max error count
Set a limit for the number of errors allowed before processing is terminated
for the task. When the SQL Server fast load option is selected, each error
corresponds either to a row-level failure detected by the Transform Data
task or to a batch failure. The value of Max error count includes the number
of row-level errors detected by the Transform Data task plus batch failures.
When the Max error count value is exceeded, task execution is terminated.
The default is zero, which means that the task will terminate upon the first
error.

[quoted text, click to view]