I have a SSIS package that manually gets run daily. It inserts transactions from one database server to another.
How do i setup 2 date variables, based on the Max date in the Source transactions table and destination table. If the max date in the Source table is > than the max date in the destination table then insert transactions, else don't run the package.
asked Oct 28, 2013 at 08:57 AM in Default
The above problem can be solved using the Execute Package task option available in the control flow toolbox of SSIS.
For that, create a parent .dtsx package. Have a Execute SQL task, that will take care of your condition as mentioned in the requirement. If requirement yields positive, run the Execute Package task, that will call your currently working package. Using variables, customize the precedence constraint to use the expression and constraint as per your requirement.
answered Oct 28, 2013 at 11:50 AM