I'm using an "Integration Services Project" / .dtsx package to load CSVs into
my SQL Server 2005. Many files represent dates as "YYYYMMDD", and I want to
convert those to feed a SQL "smalldatetime" column. How do I do that?

Hello Dave,

You could use a Script transform to do the conversion (DateTime.ParseExact)

or you could simply us a derived column.

Have a read of this about others who are doing the same thing

http://forums.microsoft.com/MSDN/Sho...74927&SiteID=1


Allan