September 1, 2015 at 1:21 am
In my SSIS package I am having one variable called user::zonevalue which data type is Int64
I want to convert to string and need to take first 3 value from the variable(Sub string)
Help me to achieve above scenario
September 1, 2015 at 1:28 am
What have you tried so far?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 1, 2015 at 1:31 am
I created 1 variabel with string data type.
and on expression I tried to convert zonevalue variable to string using (WST_D18) but not getting
September 1, 2015 at 2:25 am
Hi
For unsigned:LEFT( (DT_WSTR, 20) @[User::zonevalue],3)
Regards.
Mike
September 1, 2015 at 2:34 am
vipin_jha123 (9/1/2015)
I created 1 variabel with string data type.and on expression I tried to convert zonevalue variable to string using (WST_D18) but not getting
May I ask how you ever expected to extract the first three characters from anything, when the expression you tried does not even contain the number 3?
It seems that you did not try very hard and instead waited for the good people here to solve it for you.
You've been using SSIS for a while now and this is not advanced. You should at least have an idea how to solve these problems, or know what to search for if you cannot.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply