Hi Anthony,

Instead of returning null, try outputing the computed string to an
error row. This will allow you to check that the dates are being
correctly formatted into strings.

Also - this type of thing *is* possible using derived column
expressions (but for simplicity in this case using 2 derived column
tasks would be easier. 1st converts to string (and pads the leading
"0"), 2nd joins strings and inserts dividers). I would also recommend
using the date string format "yyyy-mm-dd" as I believe in SSIS this is
universally converted correctly.

You can also do away with all those case statements by doing:

Dim syymmdd As String
syymmdd = Right("000" + Row.OBIVDT.ToString(), 6)

at the top and then using syymmdd.Substring(...) when you're inserting
your dividers.

Good luck!
J