I have a variable(Object Type) which holds data as shown below:
Acc No Name
So for the above Sample Data, i need to take this variable in Script Task and produce a result set like :
Acc No Names
165 Meg, Jhon
This is how i need the result set and i need to load this result set in my destination Table.
I can do this using SQL, but i my Mgr don't need it in SQL for some reasons.
So please help me either sharing me some sample scripts which will help me to solve this....or even u can suggest me a diff way of doing it using any other components in SSIS.
Thanks in Advance..............
View Complete Post