August 19, 2016 at 3:00 pm
hi,
I am having difficulty writing expression to get the value from a string .
example:
E:\Temp\ATT_Hierarchy\Test_COR.xlsb
Need the value "Test" from above string in ssis expression.
August 21, 2016 at 11:25 am
komal145 (8/19/2016)
hi,I am having difficulty writing expression to get the value from a string .
example:
E:\Temp\ATT_Hierarchy\Test_COR.xlsb
Need the value "Test" from above string in ssis expression.
I created a string parameter called Val containing your example string.
The following expression extracts 'Test' from it:
Token(TOKEN( @[$Package::Val] , "\\",TOKENCOUNT( @[$Package::Val] , "\\")),"_",1)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
August 22, 2016 at 9:11 am
Thanks Phil for replying. It works.
August 22, 2016 at 9:12 am
komal145 (8/22/2016)
Thanks Phil for replying. It works.
Cool, no problem.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply