>>I'm having a look at SSIS.
>>
>>Do you have any idea how I would split my output csv files to give seperate files depending on the data selected.
>>
>>So lines with a type of AV01 would go in AV01.csv and AV02 would go in AV02.csv
>>
>>Thanks
>
>I think you will need Conditional Split Transformation. Check http://msdn.microsoft.com/en-us/library/ms137886.aspx


Thanks Naomi.

Have a good weekend.