value in a Dynamic Property task using the results from a SQL Select statement?
Note: the global variable has already been created with no value prior to creating the Dynamic Proprty Task
Like so -
Declare @gvQueryCount numeric(1)
SET @gvQueryCount = (SELECT Count (*)
FROM Balancing_totals
WHERE (data_src = 'VIADRUG') AND (Paid_Year_Mo = CONVERT(varchar(6), DATEADD(m, - 1, GETDATE()), 112)))
SELECT @gvQueryCount