Browse by Tags

• Convert String date
• Script Task
• SQL Server 2005
• SSIS
• VB .NET

• SSIS - Convert various String date formats to DateTime with the Script Task

  The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just copy and paste the code in your Script Task (paste the function outside Main() ) and it works right away. Supported date formats: YYMMDD... Posted Jun 12 2008, 02:01 PM by jorg with | with 3 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Script Task, VB .NET, Convert String date, Code