MS SQL Server DTS - Execute SQL Task question

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Execute SQL Task question

2006-03-27, 3:28 am

in executing a SQL Task, i will create a #temptable with records inserted in
it.
can i then save the record from #temptable to Excel ?
if yes, now ?

thanks.

Ilya Margolin

2006-03-29, 9:29 am

TA,

It has to be a global temp table and it is accessible from the rest of the
package.

Ilya

"TA" <TA@discussions.microsoft.com> wrote in message
news:D59D96D0-867E-41FB-B3A1- 84ECEE97BD1C@microso
ft.com...
> in executing a SQL Task, i will create a #temptable with records inserted
> in
> it.
> can i then save the record from #temptable to Excel ?
> if yes, now ?
>
> thanks.

Sponsored Links