You can use the parameters button if you are using SQL Server 2000 to
supply values to the ? Placeholders by matching them to Global
Variables.

So in your example you will have 1 * Output variable and 1 * Input
variable

In SQL Server 7 you will need to use something like this

Global Variables and SQL statements in DTS
(http://www.sqldts.com/Default.aspx?205)


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

Thanks for your reply. Still I am not sure how to use this O/P variable in SQL statement.

I have SQL 2K.

My confusion is :

This is my task in DTS
Both this variable decalre in dts pckg/global variable option..

Rundate as Date
RudateforSQL date (Rundate<> RudateforSQL do not have same value)

select
x1,x2 , ?(RundateforSQL) from XYZ where x1= ? (Rundate )

Can I assume that if I exceute this SQL Statement task then it will retun
variable value (RundateforSQL) in result set. Actually when I try this I am getting some memory error and DTS pckg gets closed..

Thanks once again!





"Allan Mitchell" wrote:

If you are getting a memory error then this suggests something may be
wrong with your SQL Server.

I think you have the methodology slightly wonky.

The RunDateForSQL should be assigned as an output variable by you
picking up a field in your statement i.e.

Imagine I have this statement

select au_id, au_lname from authors where au_fname = ?

I would have

1 * Input global Variable (?)
2 * output (Row Value) global variables

So in your example you should be choosing an attribute in the source
table and assigning it to the global variable RunDateForSQL

Does that help



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