Although I agree with the guys that why try re-invent the wheel when someone or some company has already done this and can solve you problem simply, sometimes the resources...

Ok this is my last try at answering this, as I hope this can help or I'm just misunderstanding what you are trying to do :

You probably wont need...

Hi, I think you took my two replies and merged them into one.

I didn't think that you would need the derived column object anymore as you needed to do...

rui_fro (5/8/2008)

---

Yes, I'm using SSIS.

OutputSalesHeaderStatus(type:integer) is an output of a lookup. If that output is 1, then a field in another table is updated. It cannot be null.

Is there other...

Are you using SSIS here? Assuming you are then your expression should be a boolean expression so something like ISNULL([expression]) ? 'TRUE' : 'FALSE'

Hi Vvek,

You do have to have the upper and lower limits within the lookup table for the query in the advanced tab to work. I have now used this...

Hi Jamie, thanks for your interest on this topic.

To answer the second part of your query first, the decision to implement as a dataflow rather than use the T-SQL...

Hi Colin,

I do agree with your explanation and what BOL offers.:D

donald.jones - asked a similar question to the original post and I was specifically answering his question.

(So by setting...

Hey there,

use set dateformat (dmy) or ymd etc... before you use your cast or convert statement in your query. This will eliminate dates that will be out of range.