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 |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2014-02-10 : 12:04:35
|
hi guys-
Does anyone know of an artical where I can see how to handle Row Level error. My intention is to capture the ErrorCode, ColumnName, Native ErrorMessage (description) to log it to an error table/
My Source/Destinations are both OLE.
Any suggestions?
Thanks!
--------------------------
Joins are what RDBMS's do for a living |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-11 : 00:40:46
|
You can do it by adding error flow path. for that in source set OnError option as redirect row. then link the error flow to a destination and you'll be able to get error rows with error information
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
 |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2014-02-11 : 10:12:56
|
Visakh, thank you man!!
Any links (preferred) please?
Thanks!
--------------------------
Joins are what RDBMS's do for a living |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Error Level Row handling 2012...