Steve Dell
SSCarpal Tunnel
Points: 4623
More actions
June 25, 2012 at 2:39 pm
#392600
Hi !
I would like to Swap the values in a column called Store ID using the derived Coulmn in SSIS
Below is my expression and could some one guide me here .. Thanks in Advance
(StoreID==4)? 10: StoreID || (StoreID==10)?4 :StoreID
Koen Verbeeck
SSC Guru
Points: 259105
June 25, 2012 at 11:34 pm
#1505388
Try this:
(StoreID == 4) ? 10 : ((StoreID == 10) ? 4 :StoreID)
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2012 at 2:33 pm
#1505845
Thank you very much ... that worked for me 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply