Source is varchar, want to convert to datetime but need to null any bad dates
first.

Can't use the derived column transformation as it doesn't support the ISDATE
function.

I could feed the error rows to a derived column which converts to null based
on errorcode and then union all with the successful rows but this is a
cumbersome option.

I'd prefer a solution that doesn't involve script components or ole db
commands.

Thanks in advance
David

Hello David,

Why not use a RegEx transform? That way you can validate the value.

We have one here. We'd love to know how you get on with it as well

http://www.sqlis.com/default.aspx?91


Allan

Thanks but I have to keep the installation clean so I won't be using any
third party components.


"Allan Mitchell" wrote: