String datetime conversion to DT_DBTimestamp

[John Nickell]

This is probably a question where I hopefully just need pointing in the correct direction.

I have a source system providing me date/time values like this:  '10/14/2025 6:00:00 AM'

I need to convert this to a DT_DBTimestamp type value.

The built-in Derived Column fails to convert this properly using  "(DT_DBTIMESTAMP)new_eventtime"

Attempting to 'cast' the column as the desired type in the "Derived Column plus" fails as well, when just trying to set a new column with the desired datatype based on the original column and doesn't provide access to the more complex casts (only Bool, Num, parseInt, and string)

The JavaScript Component Script Conversion Transformation looks promising but I'm not sure how to integrate it into the dataflow.  If I map it to the output of the previous step and transform the desired column, that's the only column the next step can see. I don't want/need to transform all the other columns to the same DT_DBTimestamp data type. 

What's the process to reintegrate my transformed column into overall process? 

For a word picture the prior step is a merge of the two source systems. I need to convert the column from one source system, add some additional columns based on logic (Derived Column Plus) and then push these results to a REST destination object. 

[Ivan Peev]

Hi John,

I just created a quick test package with the same string value and conversion and there was no failure. Find attached the test package I have created.

[John Nickell]

Thanks, I tried again, and it is working with the default Derived Columns.  It'd be nice if I could do similar in the Derived Column Plus transformation since using the stock Derived Column requires splitting the action into two steps. 

[Ivan Peev]

John,

Why do you have to split into two steps?