Ladies and gentlemen,

I have a question for you. I want to export data from an SQL db into Excel.
I want to execute multiple sql statements in the same dts package. (By now
your thinking: "That's easy...") But I want the results to be in different
tabs (sheets) in the same excel workbook.. (For instance result from query A
in tab A and so on).

Is this possible? Is there an easy way of doing this?

I'm quite new to dts. I've just gotten past the whole "using the wizard"
thing. Go easy on me.

Thank you for your help!

Cheers,
Elise

Hi,

...I think I figured it out...

It seems to be a "newbie" question that one. BUT in case anyone of you
should be wondering, you can easily solve that one by:

- Adding new "Transform Data Tasks" between your connections (the SQL server
and the Excel sheet)
- Adding different SQL statements for your "Source" in each of the
connections
- Creating new tables for your "Destination" for each of them

The results of the different "Transform Data Tasks" then appears in
different tabs in the same spreadsheet.

One important thing is to remember to set the sequence in "Workflow
properties". That avoids several task competing for the connection at the
same time.

If anyone has suggestions for a more elegant solution, please let me know.

Thanks,

Elise (..learning..)

"Elise" <elise.bakke (AT) gmail (DOT) com> wrote