If I'm using the DTS IMPORT/EXPORT WIZARD, is there a way I can specify that
data transfer should not stop when it encounters an error (like a destination
col which does not allow null Values) , but shld log the error to a file and
continue transferring the rest of the data?

Using the wizard, is it possible to specify the max no of errors and an
error log file (the way u can do using a DTS Transform Data Task)?

You can only set limited properties in the Wizard. You would never expect
every option to be exposed in a Wizard otherwise it defeats the point of
having it. You can create the package in the Wizard, but instead of
executing it there and then, elect to save it first. Then you can open the
package, make your changes and then run from the designer


--
Darren Green
http://www.sqldts.com

"sqluser" <sqluser (AT) discussions (DOT) microsoft.com> wrote