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 |
|
sundeepsqlteam
Starting Member
1 Post |
 Posted - 2011-04-03 : 09:19:56
|
| Hi All,I am getting a strange problem in SSIS 2008 with Lookup transformation,I am refercing a table in lookup ehich has almost same data as with Source data, but with only 2 new records in the source, so, in that case i am redirecting the unmatched rows to the error output, but now the problem arises, as i am getting NULLs in the error output.Please help me on this.Thanks,Sandeep |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2011-04-03 : 12:03:05
|
| Hi SundeepSqlTeam,i generally create in two OLE DB Destinations; one for lookup match output and second for lookup no match output. when click on edit of lookup transformation there is on general tab special selection "Specify how to handle rows with no matching entries" and you set it to: Redirect rows to no match output.this ought to do it. |
 |
|
|
|
|
|
Lookup in SSIS 2008