Hello,

I have a Stored Procedure that returns data from a # temp table. This proc
works fine with query analyzer. When I try to run this query from a DTS
package exporting the data to an excel , I cant seem to parse the query in
the "Transform Data Task Properties" as it cannot find the #temptable. Any
idea of how to get around this and have dts to pump data to excel by
executing a storeproc having #tables.

Thanks
Shyam

Do you create the # table up front of the transformation task and then try
to reuse in the transformation task?

That won't work.

You could try using a ## table

The fact that you are constantly using a # table would for me make it a
candidate to be made a permanent table.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"shyam venkatram" <shyam (AT) vmware (DOT) com> wrote