I was recently dealing with importing a DBISAM (Btrieve) database to SQL Server, which had separate date and time columns where I wanted to import a DateTime. Using the ODBC driver and a DataReader data source, it was returning the date as the DT_DBTIMESTAMP type and the time as a DT_I8 long integer.
I tried using the Derived Column transformation to combine them, but never could get it to work. There simply aren’t many date functions supported by the Derived Column formulas. Finally, I settled on using the following VBS script using the Script Component transformation:
If Not Row.StartDate_IsNull Then If Row.StartTime_IsNull Then Row.StartDateTime = Row.StartDate Else Row.StartDateTime = Row.StartDate.AddTicks(Row.StartTime) End If End If