Using global variables in DTS task
Posted on 2005-03-08
I have a simple DTS task in SQL Server 2000 to update the data in a field, (using "Execute SQL task") but I want to create some other SQL tasks within the DTS to update data in other fields, based upon a predefined date.
I'm trying to define this date as a global variable that all SQL tasks can reference, but it hasn't worked as yet.(using Package Properties >> Global variables tab)
Ie; If I have 3 "Execute SQL tasks" with a date variable in them, I want to specify the same date to be used in each task (without having to edit each task) ---really appreciate help!