SQL SERVER 2010
i have two different packages within 2 different project. Lets Say Package X and Package Y. There are 15 and 10 task in the packages respectively.
there is 1 task common in both the packages. lets say it as beta
How can i design in such a way when beta is run in Package X than it should not run in Package Y and when it not run in Package X then it should run in Package Y.
Both the Package run through agent Job. Package X start first.
Please share your idea if it is possible to achieve in SSDT.