Source = .csv Field = datetime
Possible values in source file = yyyyMMdd (20071008) OR 00000000
Due to the 00000000 value a normal "Date Time String transformation" fails. As such I would like to use an active X script to replace the 00000000 value with a NULL value leaving the yyyyMMdd value if available. I am unsure of the syntax in an ActiveX script. I have been trying something like the following without success.
Any help would be appreciated.
If DTSDestination("REF_DT") = ("000000000") Then
DTSSource("Col014") = IsNull Else
FormatDateTime( DTSDestination("REF_DT") , yyyyMMdd ) = FormatDateTime( DTSSource("Col014") , yyyyMMdd )