I created a SSIS package that will update certain tables every year. Prior to updating these tables I want to run the "execute sql script" to change the current year to the next year automatically. For instance, I want to 2011 to 2012. I know I can update a column like...
set columnname = 2012
where columnname = 2011
But I want to have this done automatically at the beginning of my SSIS package and not for just this year, but years to come, without having to worry about it. Is there a sql script that would perform this. Thanks in advance.