I want to design a package that will have 2 parts (2 parts of data flow). The package will be executed by scheduled Agent JOB.
One part (DFT) should load data daily while the second part should load weekly.
So I am thinking of 2 approaches:
1) Design 2 packages - one for each and have 2 Jobs scheduled accordingly
2) Design one package and use constraint to check current date/day. Execute first part and if this is Sat then the second DFT.
View Complete Post