DTS Multiple Selects into One Extract

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
.

Quantcast