DTS and Excell

Help.
Can someone help me with a DTS? I have a curser that creates a temp
table and then sever select statments from the tmp table. I am tryin to
place each out put from the many select statements in its own excel
worksheet.Hi
"TG" wrote:
> Help.
> Can someone help me with a DTS? I have a curser that creates a temp
> table and then sever select statments from the tmp table. I am tryin to
> place each out put from the many select statements in its own excel
> worksheet.
The way I would probably do this would be for each select statement to
require it's own transformation with the excel file as the datasource and the
destination table being the datasheet that you are inserting into.
HTH
John