Export same data to two separate Excel sheets

[qberta01]

Can anyone tell me if it's possible for me to have one SQl data conenction that can push the exact same data to two different locations?
I already do the following with sucess for only one spreadsheet:

1. Delete the existing spreadsheet from its locations.
2. Create the Excel spreadsheet.
3. Perform Data Transform task that runs a SQL query for needed data and pushes out into created spreadsheet.

When I try to throw in another spreadsheet I run into problems.

Any help would be great!

Thx,

Q.

 

[AlexCuse]

Either use vbScript to copy your first copied spreadsheet to your second, or use a second data pump task to push it out into the second one.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom