I'm using this sql query to select the field which I want, if it is a datetime field I use to_char.

SELECT "T$ORNO", TO_CHAR("T$TRDT", 'mm-dd-yyyy') AS "T$TRDT"

After this in the transformation I...

Thx provost, I will give it a try and let you know !!

If I dump the date records from oracle into the sql database as varchar (20) I only see a date, no time so I don't have to convert it !

Can you explain in detail what you mean with staging table ?

That's correct, I'm using

TO_CHAR("T$DDAT", 'mm-dd-yyyy') AS "T$DDAT"

in my SQL query, and

If IsDate(DTSSource("T$DDAT")) Then

If DateValue(DTSSource("T$DDAT")) < DateValue("01-01-1753") Then

DTSDestination("Leverdatum") = DateValue("01-01-1753")

Else

DTSDestination("Leverdatum") = DTSSource("T$DDAT")

End If

Else

DTSDestination("Leverdatum") = NULL

End If

in my ActiveX script.

The...

I'm now using an ActiveX script like this :

If IsDate(DTSSource("T$LVDT")) Then

        If DateValue(DTSSource("T$LVDT")) < DateValue("01-01-1753") Then

            DTSDestination("Verificatiedatum") = DateValue("01-01-1753")

        Else

            DTSDestination("Verificatiedatum") = DTSSource("T$LVDT")

        End If

    Else

        DTSDestination("Verificatiedatum") = NULL

End If

and...

That is exactly what I did and that didn't work ! But ... I'm a little new to SQL and ActiveX is also...

Ofcourse I tried that and ofcourse it works ... but that's not what I want as a result. The field must be a...

Thanx for all the replies, I managed to transfer my package to another server with the help of your replies !!