I am doing this in order to create an automation that will check the dates in the tables I am using to see if they have been updated prior to running the remaining portion of the script.
The plan is to set the variables (dates from the tables) then use the If condition to determine if they are all updated. I will also use the pause system activity to loop until true.
Anyone can help that would be great. Need an answer ASAP.
I am utilizing TDA 3.0 but I am having some issues setting variables in the automation process. I name my variable and then use a sql script to set the variable. It works to capture the date I am looking for but instead of fomatting it as a date it comes out as
Variable “Var_Dt” set to “2/7/“2012 12:00:00 AM””
Variable value = 2/7/“2012 12:00:00 AM”
The result I am looking for is just the date 2/7/2012.
The script I am using is as follows:
Message was edited by: daniel.albrecht_046