>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