Hi,

I am using a stored proc which takes three input parameters based on which
it would identify the table, and fetch the rowcount of the table before
delete and execute a delete command on some condition and perform again a
rowcount

The SP returns two output parameters of type int.

create mystoredproc
@a varchar(30),
@b varchar(30),
@c varchar(30),
@d int output,
@e int output
Begin
.....
End.

Problem:
I use a dts package, Exec SQL task and pass the input parameters via global
variables. The output variables are not set to the return value of the
stored procedure.

Whereas I run the same stored proc, declaring necessary variables in Query
Analyser, I am able to get the right results???
I have used disconnected edit to set the input and output parameters of the
Exec SQL task in the dts package.

Any reason, why the return values are not set...

Thanks
SatishTL

Have you had a look here?

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"SatishTL" <SatishTL (AT) discussions (DOT) microsoft.com> wrote

Thanks Allan, it helped me to resolve the issue.

Thanks
SatishTL

"Allan Mitchell" wrote: