I'm in the process of building an SSIS package which will be used to export telephony data on a 15-minute frequency.
The first stage of the process collates all previously-uncollated data, which I'm doing by executing a SQL task. What I then want to be able to do is to export all of that data, creating a separate file for each telephony campaign. Currently I have a table that contains each campaign name, and I want to be able to retrieve the contents of that table using a SQL query and then create a new file for each campaign name. I can't get my head around how to do that.
Can anyone help me?