Hey,

I basically added a named query to my DSV with the following sql and created a relationship between my StartedDate (PK=StartedDateKey) and TurnAroundTime(FK=StartedDateKey)

SELECT ...

Thanks for the suggestion all, the NULLIF worked perfectly

Hi Frank,

That is exactly what I'm trying to do. In my derived column however, I

ISNULL( ENDDATE) ? "1900-01-01" : ENDDATE

I get the error:

The data types "DT_WSTR" and "DT_DBTIMESTAMP" are incompaitble...

Hi,

Apologies, I should have been more clear.

My process is as follow:

I have a step which gets data from a DB2 database and populates a 'Recordset Desination', then I use...

It's an opensource database

http://oss.oetiker.ch/rrdtool/

Just wanna say thank you. This worked perfectly & made my package much more simpler. I learnt about the Recordset Destination

Hi Frank,

These are the steps i took:

1) Control Flow I created an 'Execute SQL Task' which runs the sp & gets a list of items

2) Data Flow Task - then...

Hi Toni,

Thank you for your response, I don't think I was very clear as to where my problem is. Where about in my SSIS package do I make this check?...

perfect, that's exactly what I was looking for.

Thanks alot