I have a column as : act=TUNING; svid=629; VCN=180; TI=949290689; TO=949291183; TT=494; FPID=(586653033-494)
Now i want to take the values of svid,VCN,TI,TO,TT,FPID into seperate columns.
How can i do it in ssis.
The column sizes are not standard all the time.
In one of my table in the DB , i have the token strings like token1 => svid= and token2 => ;
So now how can i use these tokens to pull the data of 629.
Please check the above question @msdn forum
Answer:
Please write the following expression in your derived column (C2 is column name)
(click on the image for larger view)
act =
svid =
TT=
TI=
TO=
Do let me know if you need more help on it.
No comments:
Post a Comment