I'm using Script Component for converting from "yyyyMMdd" string (20090115) to Date type. It is more accurate and is independant from date settings.

Script example:

' Microsoft SQL Server Integration Services user script component

' This is your new script component in Microsoft Visual Basic .NET

' ScriptMain is the entrypoint class for script components

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent

Dim provider As Globalization.CultureInfo = Globalization.CultureInfo.InvariantCulture

Dim format As String = "yyyyMMdd"

Dim errmessage As String = "place here error message/code"

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Try

If Row.InputDateString_IsNull = True Then

Row.OutputDateInDateType_IsNull = True

Exit Try

Else

Row.OutputDateInDateType = Date.ParseExact(Row.InputDateString, format, provider)

End If

Catch ex As Exception

Row.OutputDateInDateType_IsNull = True

Row.errmsg = Row.errmsg + errmessage

End Try

End Sub

End Class