> 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

"Allan Mitchell" wrote:

> 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
>
> > 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