I have two separate select statements to pull data. I want to load the raw
data into one Excel spreadsheet, into two separate sheets.

How can I do this in DTS? DTS doesn't appear to be able to transform data
into the same connection object because of duplicate object names.

Can DTS transform two extracts into two separate datasheets in one go? If
so, how?

(Ultimately, my problem has to do with linking one table to two different
tables (one-to-many) that have multiple results. It seems a "do while" type
of statement would work, but I know not how.)

I look forward to any help folks can provide.

Cheers,
Leslie

Leslie wrote:
Connections are made to workbooks, not worksheets.

Create a workbook with only one worksheet. Name the worksheet TitlePage or
something and put the name of the report in it.

Using the connection to the workbook:
Create TableA, which creates a worksheet named TableA
Pump data into TableA using first select statement
Using same connection, create TableB (creates another worksheet named TableB)
Pump data into TableB using second select statement

This will yield a workbook with three worksheets: TitlePage, TableA and TableA
Change the worksheet names a appropriate.

Thank you Ed, I will give that a try. Glad to know this IS available and
there are folks like you who know these things! :O)

Cheers,
Leslie

"Ed Enstrom" wrote: