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 |
|
RickHodder
Starting Member
2 Posts |
 Posted - 2010-03-19 : 14:44:30
|
| I have a Lookup Task that maps a STATEID field against a STATE table.There are null stateids in the table I'm passing through the lookup, so there are rows that will fail the lookup. I want to store a default value of -1 in the field for all rows that fail, and then add the rows back into the output of the rows that passed the lookup.So I know that I have to redirect the output of the Lookup, but what type of task(s) do I redirect it to in order to:1. update the stateid of the failed rows to -12. add the updated rows to the to the Lookup Match Output results?Thanks!Rick Hodder |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-03-19 : 15:30:53
|
| YOu can redirect to a database table, even a flat file. Add the appropriate destination to your reject/failed output arrow.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
RickHodder
Starting Member
2 Posts |
Posted - 2010-03-19 : 15:54:19
|
YOu can redirect to a database table, even a flat file. Add the appropriate destination to your reject/failed output arrow.Thanks!And what would I use to update the rows, an OLEDB Command?Rick Hodder |
|
|
|
|
|
|
Redirecting Lookup Error Output