hi,

i'm using SQL Server 7.
wanna use DTS to run a SP and save the result in Excel.
In SP, temp table ( #xyz ) is created & used. however during the DTS
creation, DTS will generate error msg " Error Desciption : Invalid object
name '#xyz ' "
do you have any idea how to overcome ?

next, can the result of SP, further set some condition to filter out
unwanted data before store to Excel ?

many thanks

Hi you can use temp tables in SP checkout the SP in sql query analyzer
before running it in dts package i did same in sql server 2000 it worked for
me okey...

make sure you are using this #xyz temp table with in the sp....

"TA" wrote:

Thanks.

How u call the SP in dts ?
In the SQL query box, i put "exec spABC <parameter_1>, <parameter2>

when click 'parse the SQL' button, it shows the error msg as mentioned.

cheers,

"Rajesh Kasturi" wrote:

Yes that is right in sql query box you can execute sp's
Example:
exec spname
but i have not executed sp with input and output parameters for more
information how to execute sp's with parameter go to www.sqldts.com
and search in google and msdn and www.live.com

Have a nice day





"TA" wrote: