Hello All ,
I have a Main ETL pacakage which calls all the child packages via Execute Pacakage task. All the pacakages are connected in Sequenatial order . Now , I want to control the flow of the packages from DB .
For ex ETL1 -> ETL2 -> ETL3 are the packages . Then If I wanna run the only ETL2 , generally I need to open the tool and delete the constraint and run the package . But is there any possibility I can control this from DB without opening the BIDS.
Go to the complete details ...