Hi everyone,
I have designed a SSIS project which in which there are 3 packages.
When I run the first package it creates some tables in database and using Execute Package Task jumps to second package and run the tasks there and in last step which is also Execute Package Task here it jumps to 3rd package and executes all the steps and project runs successfully.
The above steps are working fine in Visual Studio and when run manually after deploying to SQL Integration Services Catalog folder.
But when I am scheduling the first package as SQL Server Agent Job, it only runs the first package and doesnt continue to next packages.
How can I fix this?
Regards...