Avatar of Robin CK
Robin CK

asked on 

SSIS Derived column formula if a column is blank then pick data from some other column last 11 digits else same column

I have an MS Access formula which I want to use in SSIS package Derived column

GPN: iif(isnull([resouce GPN]),iif(Len([resource])>11,Right([Resource],11),""),[Resource GPN])

The formula reads, if "Resource GPN" column is blank then take last 11 digits of string from "Resource" column.
SSISMicrosoft SQL Server

Avatar of undefined
Last Comment
Srinivas Reddy

8/22/2022 - Mon