Lookup Transformation -- sql server dts

christy
4/10/2007 11:28:03 AM

I have a source table Product and a lookup table Class based on
Product.ClassID = Class.ClassID. I need ClassName from Class table in the
output.

There are records in the Product table that don't have any class assigned
yet. I need to include those no-matchings in the output (more of a left outer
join). In the Configure Error Output, I changed the Lookup Output error to
"ignor Failure" - that seems to include the no-matchings as NULL in the
output.

Is there a way to change ClassName to "NA" instead of NULL for no-matchings?

Allan Mitchell
4/10/2007 8:23:14 PM

Hello christy,

OK

There is not way to change it from this component but how about this

use a derived column transform to replace the value of the key to something
like this

ISNULL([ReturnedClassID]) ? "N/A" : [ReturnedClassID]

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

sql server dts : Lookup Transformation