asked
SSIS Execute SQL Task Set date
I want to achieve this through Exec SQL Task in SSIS Control flow. Please suggest select MAX(EFF_DT) As EFF_DT FROM Table D (nolock) WHERE MONTH(D.EFF_DT) = month(datediff('m',-1,@eff_dt)) and year(d.eff_dt) = year(datediff('m',-1,@eff_dt)) and assign the result to a variable..
You can set the result of a SQL query to a variable by indicating your result set in the general page of the Execute SQL Task Editor. You will need to set the ResultSet property correctly, and then map the result set to your variable on the Result Set page.
