SSIS - derived column transformation
Posted on 2009-04-28
I'm bringing data in from v2000 into v2008; the two columns in question are DATETIME in the source, yet they're going into DATETIME2.
simple data flow, oledb source, sql server destination, using sql command. but,
the conversion between types DT_DBTIMESTAMP and DT_DBTIMESTAMP2 is not supported...
Now I am trying to do a derived column transformation, such that i could map the derived column to the destination, not the original
i've added the derived column transform in between the source and destination in the data flow tab. I am doing this with the understanding that i need only address the two columns in the derived transform editor, and everything else will map just fine.
derived column transformation editor
derived column name / derived column / expression / datatype
columnA / Replace 'ColumnA' / (DT_DBTIMESTAMP2,27)ColumnA / database timestamp [DT_DBTIMESTAMP]
that expression fails to parse
i've tried this, too: (DT_WSTR,27)columnA
That one parses, but it gets me back to the conversion error between types DT_DBTIMESTAMP and DT_DBTIMESTAMP2
I am surely just handling the expression in error.
Is anyone able to advise?