I need help.
Here is my sample data
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