sql server dts: On SSIS Insert Error - How do you extract the offending record -- sql server dts

On SSIS Insert Error - How do you extract the offending record

rfinlay
2/6/2006 2:56:18 PM

sql server dts: 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

Re: On SSIS Insert Error - How do you extract the offending record

Darren Green
2/7/2006 11:54:28 PM

[quoted text, click to view]

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