Phil Parkin (4/23/2013)
A possible problem for you is where your input file suddenly contains durians and kumquats and you have not built the conditions for directing these new fruits into your conditional split. If you need this type of dynamic processing, a different approach is required.
YES! I knew you would see that. Durians, huh? Wow do they stink! Either way. The "Fruit" table is provided to us by a keying crew somewhere in Bangalore, India, thus if we get Durians, it's because we asked for it. If we got them without asking for it, there is a bigger problem. On that note, the team over there is pretty good.
Regarding the double quotes - it's because SSIS is not based on T-SQL. The SSIS expression language is more like C# with some SQL-like functions added in. C# uses double quotes for string literals
I thought it smelled like C something....ahhh... college days... that was a long time ago.
Ok. So I'll give it a shot and see what I get.
Thanks again, Dude.
P.S.... Did you know that Durians are outlawed on pubic transportation in some of the countries they are grown/imported?