Setting Global Variable with GetDate()

#1

Within a Dynamic Properties Task, I'm trying to set a Global Variable to the
system date using the query: Select GetDate(). This should work, but it's
not. I can set a variable using a query that selects a date from a table, but
not using GetDate.

Help needed,
Rob

#2

Are you getting an error message?
I can do it on my end. What data type for the global variable are you
using?

--
Simon Worth

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

Quote:

Within a Dynamic Properties Task, I'm trying to set a Global Variable to
the
system date using the query: Select GetDate(). This should work, but it's
not. I can set a variable using a query that selects a date from a table,
but
not using GetDate.

Help needed,
Rob

#3

Works for me.

Choose a database connection(SQL Server)
Now enter a "QUERY" of SELECT Getdate() against this connection for the
Value property of your GV

This works for me.

Allan

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

Quote:

Within a Dynamic Properties Task, I'm trying to set a Global Variable to the
system date using the query: Select GetDate(). This should work, but it's
not. I can set a variable using a query that selects a date from a table, but
not using GetDate.

Help needed,
Rob

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Setting Global Variable with GetDate()

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Setting Global Variable with GetDate() - 03-10-2005 , 12:33 PM

Re: Setting Global Variable with GetDate() - 03-10-2005 , 12:47 PM

Re: Setting Global Variable with GetDate() - 03-10-2005 , 12:49 PM