This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/
This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/06/12/ssis-convert-various-string-date-formats-to-datetime-with-the-script-task.aspx
Thanks. Exactly what I was looking for.
I have many dates in various string formats. This should work great for me, but I'm not sure how to implement it SSIS. (newbie) I've been using a derived column.
Thanks.
jjf, you should not use a Derived Column but a Script Task, just like you can read in the blog.
Next to the Script Task you need a SSIS String variable that contains your date.
Good Luck!