I have some SSIS package which is using variables. I built an expression for some purpose and I am using the following expressin in my ssis package.
"_GROUP" + (DT_WSTR, 2) (((DT_I4 )(SUBSTRING( @[System::MachineName] , 12, 3 )) + 1)/2) + "_"
The purpose of this is to get a group number basing on Machine name (taking the last two digits in the machine name) and dividing that number by 2.
I am getting data conversion error if evaluateasexpression is set to TRUE. Can some tell me why? Thanks in advance.
View Complete Post