manibad (4/18/2013)
thanks for everyone who have replied..Actually i am not in a position to work on SQl or Script task and code the data to achieve my destiny..i can do it only in SSIS.Is there any possiblity to achieve it by SSIS and specfically using dervied column.
I mentioned a Script Component, not a Script Task.
Regardless of that, both are 'in SSIS'.
If you do find a derived column solution, please post back, because I'm sure it will be useful to others.