Hi,

I've got a SQL taks in DTS 2000 and a global var with a float number. I try
to get the value of the parameter in the SQL task:

declare @Total float
update KPI set value=@Total where code=123

When I hit "Parameters" to map the variable, I get a message: Query does not
contain any parameters.

How can I fix this?
thanks

Hello Philippe,


Try simply this script :

update KPI set value= ? where code=123

and hit 'Parameters'

('?' should be the placeholder for your GVar)

This problem is fixed :-)
But (there's always a but)

Whe I do this, the default value 0 which I specified in the glmobal
variables is written into the table instead of the variable value.

The SQL statement which gets the number out of the table works because I
tested it with Query Analyser. Is there a way to check this or what am I
doing wrong?


"Davide" wrote:

Hello Philippe,

I've some problems to understand:

You set the value of the GVar using a query, and then you update a table
with the value of this Gvar ?
Before updating the table you should test the value of your Gvar, using an
ActiveX script for example...