MS SQL Server DTS - General problem with global variables

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

General problem with global variables

Niklas

2005-07-27, 7:27 am

Hi,

I get rid of these global parameters. I've a simple SQL task :

select lasttime from messagetrackingentry

I store the value of lasttime (datetime type) in a global variable of type
date.

Using this one as input parameter for a second select:

select * from messagetrackingentry
where lasttime > ? doesn't work.

Every time, the first task is executed, the type of the global parameter in
the definition screen has changed to NULL and as a result executing both
tasks results in 'Parameter type is not supported'.

Please help!

Sponsored Links