MSDN Authoring Template

The other feature that exists in DTS Transformation operations is a very powerful ability to convert strings and other non-datetime data, using the NLS information of the instance of SQL Server. For formats that have date/time data stored as strings, this crucial functionality can allow the import to proceed as the user would expect it to. ................
................