Filter records in DTS

[dwight1]

I want to filter records in DTS. I am transfering data from AS400. The format of the date field is 111805 and 11805. I can use the string
WHEN len(LDEPD6) = 6 THEN substring(LDEPD6, 1, 2) + '/' + substring(LDEPD6, 3, 2) + '/' + substring(LDEPD6, 5, 2) WHEN len(LDEPD6)
= 5 THEN substring(LDEPD6, 1, 1) + '/' + substring(LDEPD6, 2, 2) + '/' + substring(LDEPD6, 4, 2) END

in the query analyzer but am not able to use the same string in the DTS.

Can any one advise me how to read the 111805 or 11805 as a date field and set filter on the data transfer.

One more thing, if i just transfer the data the field comes as a decimal and we cannot apply the above string. So the decimal has to be converted to either char/nvarchar before applying the string.

Thanks in advance.

Dwight