Hi Guys,
I need help.
Here is my sample data
ID,FNAME,STATE,AGE
1,JIM,CA,12
2,CARLOS,NY,14
3,JENA,CA,15
4,TIM,GA,12
What I want, I want to create an SSIS Package, where I can create a .csv file from the above data. A number of files created it depends on how many states
of data I have in the table. In above example, it should create 3 files. (1 File of all CA DATA,2 FILE FOR NY DATA,3 FILE FOR GA DATA)
Please advise how I can accomplish this in SSIS.
Thanks in advance