Hi Folks :
I have an excute SQL Task in DTS Package. I am excuting a
sproc which has three output parameters . I would like to
assign the values to the Global Variables in the Package
so that I can use the Global variables in another Task .
But when I parse the code and click for the Parameter
button in the Excute SQL Task I get the message that the
Query does not have parameter . What I am doing wrong .
How can I resolve the Issue.

Here is the Code in the Execute SQL Task.
set nocount on
declare @BatchName varchar(20),
@JobNo INTEGER ,
@Rundate DATETIME

exec Empower.U_EppNonEppProcess
@BatchName output,
@JobNo output,
@Rundate output

select @BatchName as BatchName, @JobNo as JobNo,
@Rundate as Rundate

Thanks

Dhanraj

Here's an article that should get you started

Global Variables and Stored Procedure Parameters
http://www.sqldts.com/default.aspx?6,102,234,0,1

--


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

"Dhanraj Mahendra" <dmahendra (AT) ryland (DOT) com> wrote

Hi Allan :
Based on the Global Variables and Stored Procedure Parameters
http://www.sqldts.com/default.aspx?6,102,234,0,1 article I wrote my
code. I still could get it to work. If you can tell what I am missing
will be help full. The site was very helpfull

Thanks

Dhanraj



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <OxwaaULQDHA.3664 (AT) tk2msftngp13 (DOT) phx.gbl>, Dhanraj Mahendra
<anonymous (AT) devdex (DOT) com> writes
What does your code look like now?
Make sure that the only result set produced by all code and procedures
used is the final select for the output parameters.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com