Home Forums SQL Server 2005 SQL Server 2005 Integration Services Convert String DataType to Date datatype in DTS RE: Convert String DataType to Date datatype in DTS

  • May 4, 2009 at 4:59 pm

    #988468

    It seems that you need to modify the script, which looks curiously like a VBScript DTS script.

    Try replacing this line

    DTSDestination("CreateDate") = CDate(DTSSource("Col095"))

    With this

    If IsDate(DTSSource("Col095")) Then

    DTSDestination("CreateDate") = CDate(DTSSource("Col095"))

    End If

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.