I'm trying to fix some errors in a SSIS package that occured after
migrating from a SQL 2000 DTS package. I've been fairly successful so
far, but I'm failing miserably on a data conversion. How can I convert
a string formatted as

Jan 11 2006 12:00:00:000AM

to a smalldatetime?

Any help would be greatly appreciated!

-Erik

Hello ealmquist (AT) gmail (DOT) com,


What have you tried so far?

What errors do you receive if any or do you just receive the wrong dates?

One obvious way to do this is to use a Script component

What is the source?

You could also use a derived column and Kirk has some simple examples that
you could extend

http://www.sqljunkies.com/WebLog/kni.../14/16073.aspx

Allan