I have a simple SSIS package that runs and SQL query and outputs the results to a csv file. What I want to do now is put multiple queries into the package and output the data into multiple files - how do I do this or do I have to create multiple packages.
You can have multiple data flow tasks in one SSIS package (in the data flow tab). You will need to create the appropriate source and destination connection managers and attach to the data flow tasks. Also see here: http://msdn.microsoft.com/en-us/library/ms141122.aspx