venkatareddy.mora (12/20/2012)
Hi,I have a flatfile which contains 100 diff locations, i want split the data based on the name of city
Ex:-
cid,cname,loc
1,aa,us
2,bb,uk
3,cc,russaia
........ upto 100
so want split the data based on condition in ssis using condtionalsplit
i can write loc=='us'
loc=='uk'
......
shoul i write like 100 expressions or is any way?????
Can you explain a bit about why do you need to do this?
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.