I need to split the DB into Current(2012,2013,2014) and History(previous to 2012).
Every year I need the oldest year should move to history DB i.e if 2015 enters then 2012 should move to history.
And it consists of 5 fact tables, and I need to do the whole thing in a single package.
So for that I have taken 5 data flow tasks in a sequence container to run them at a time but the thing is to check the condition that it should run at the year starting day on 1st January.
So what could the task that can be taken before the sequence container in order to check the given condition(if the condition satisfies then only the sequence should run.....) and In what way would the query be put into the task?