SSIS: DT_DBTimeStamp to Date in conditional split

Question

SSIS: DT_DBTimeStamp to Date in conditional split

kkran 831

Hi everyone - I am trying to convert the below sql statement in the SSIS conditional split. Could you please let me know if this correct/valid ?

Column : Last_Updated_DT is 'DT_DbTIMESTAMP'

SQL Statement:

SSIS condtional Split:

Olaf Helper 47,581 Reputation points

2022-03-01T06:39:26.623+00:00

SQL Statement

That's not a SQL statement, it's a screenshot where no one can work on.
Please post table design as DDL, some sample data as DML statement and the expected result.

Answer accepted by question author

0 additional answers

Your answer

Olaf Helper 47,581 Reputation points

2022-03-01T06:39:26.623+00:00

SQL Statement

That's not a SQL statement, it's a screenshot where no one can work on.
Please post table design as DDL, some sample data as DML statement and the expected result.

Answer 1

Hi @kkran ，

What you do in conditional split is correct.

You may enable the data viewer to check if the data is right.

data-viewer

From my side, I use 2022-01-10 as the condition date, the result is shown below.

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

SSIS: DT_DBTimeStamp to Date in conditional split

0 additional answers

Your answer