Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
 Posted - 2007-10-11 : 15:58:32
|
| Using BCP or BULK INSERT you can specify an Error File (-e and ERRORFILE). However this does not seem to be exposed in SSIS via the Bulk Insert Task. Does anyone know if I'm missing something and the Property is called something else or if can be accessed via script?Cheers,-Ryan |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-10-11 : 17:00:18
|
Bah, I must have glanced right past it. From BOL: quote:
The Bulk Insert task does not log error-causing rows. If you must capture this information, use the error outputs of data flow components to capture error-causing rows in an exception file.
|
 |
|
|
|
|
|
Bulk Insert Task - Error File