|
Home > Archive > MS SQL Server DTS > March 2006 > DTS call SP with problem
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 |
DTS call SP with problem
|
|
|
| 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
| |
| Rajesh Kasturi 2006-03-23, 3:31 am |
|
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:
> 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
>
| |
|
| 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:
[color=darkred]
>
> 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:
>
| |
| Rajesh Kasturi 2006-03-24, 7:39 am |
| 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:
[color=darkred]
> 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:
>
|
|
|
|
|