Share via

EXPRESSION ISSUE

Sunny 60 Reputation points
2023-11-28T08:39:08.2833333+00:00

I have a column like

A1101

B1102

C1103

Can i use ssis expression to make the data like

1011A

2011B

3011C

SQL Server Integration Services
0 comments

Answer accepted by question author

ZoeHui-MSFT 41,551 Reputation points
2023-11-28T08:43:40.4533333+00:00

Hi @Sunny,

You may try with REVERSE.

REVERSE(yourcolumn)

User's image

REVERSE (SSIS Expression)

Regards，

Zoe Hui

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

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.