Moving data from a Sybase (source) database to a SQLServer (destination)
database. Some of the inserts are failing and I have been able to get the
following kind of info on the offending row(s).

Description: "The Bulk Load failed. Unexpected NULL value in data file row
22 column 3. The destination column (phone) is defined as NOT NULL."

What I need to be able to do is capture the source record so that I can
redirect it to some sort of log. This would allow me to identify the
offending record to my business clients who would then be able to fix it so
that it did not fail on the next iteration.

Any help would be appreciated.

Thanks

rfinlay wrote:

Have you tried using Error outputs? You have the ability to re-direct
failing rows to a special error output. Try scanning Books Online for an
overview first.

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