I wish to import data from Excel File in SQL SERVER Table
towards DTS Task. At the time of the importation I want to
recover the data which could not be to import in a table
of exception. Does anyone know how could i proceed.

Thanks

In DTS 2000 the transform data task can spit error rows out into a file, you
could then process this file. You need to change the type of error handler
on the last page of the transform data task dialog from 7.0 Compat to source
error rows and dest error rows. You may need to change the batch size to 1
(which is MUCH slower) to catch the error rows depending on the type of
error.

--
-Euan

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.

This posting is provided "AS IS" with no warranties, and confers no rights.

"Meno" <neotech_logistique (AT) yahoo (DOT) fr> wrote