SQLTeam.com | Weblogs | Forums

SSIS Help


#1

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


#2

use the conditional split task.


#3

Inside the for each loop container use data flow task as dynamic .

Refer the below link for each container task: