Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.