Lowell (1/10/2014)

---

I've got just enough exposure to SSIS to think the following is true: an SSIS project defines all it'sc olumns and datatypes before it does anything like insert them or export them to excel;

I hope there's a bit more advanced stuff I'm not familiar with.

I've got a task where the basic idea is going to be some developer gives me 1 to N queries which represent a collection of reports. the columns are not defined in advance.

So the task would be to create an excel worksheet, and for each query, add a worksheet and populate it with the script results.

I can do this easily in C#/VB.net, but they want a re-usable SSIS model that a BIDS guys might use use for future similar issues, without involving a developer and a block box executable.

more specifically, say i receive 4 queries that are going to return results. I'd want to build a specific package for those four queries, that generates an excel sheet with four worksheets;

then if the query changes, it's a rather simple matter to tweak the query.

if i have a different group of reports, i'd create a new project , and use the original as a model for doing the same steps.

does anyone know if it's possible? the resultset would always come from a query against SQL server.