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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-10-03 : 18:36:06
|
| I have done the “redirect row” for an SSIS task. And the bad records are promptly redirected to a error table. However how will I come to know – what was the reason for those rows to get rejected? ------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-03 : 19:10:37
|
| What did you see in Progress tab? |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-10-03 : 21:47:52
|
| Surprisingly, Didn't see anything there. I have lot of bad records rejected for various reasons. I need to find why each one was rejected. Thank You , Sodeep for your help, in the earlier thread.------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-03 : 21:51:48
|
| you are Welcome!So do you know how many got rejected? and did you use data viewer to see? You can right click Red arrow(task flow) and see what is going on? |
|
|
|
|
|
|
Capturing error in SSIS