Share via

SSIS expression in column

ELEVEN 80 Reputation points
2023-09-25T00:44:22.4533333+00:00 
name_2023-07-01
upgrade_2023-08-10
code_2023-08-25
change_2023-09-06

I have a column shown above, how to only get the date and delete all the word before the date?

SQL Server Integration Services
0 comments
Answer accepted by question author
  1. ZoeHui-MSFT 41,536 Reputation points
    2023-09-25T01:41:34.6+00:00

    Hi @ELEVEN,

    You may use token expression in SSIS.

    TOKEN([yourcolumn],"_",2)

    User's image

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,586 Reputation points
    2023-09-25T05:57:46.36+00:00
    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.