To automate data loading process, we have to schedule ETLs. To execute multiple Packages in parallel we can follow below options.
- Create a master package and execute other packages according to the required sequence using Execute Package Task.
- Create jobs to execute packages and start those using another job.
In the first option, I had an issue related committing the transactions while trying to execute packages in parallel. Due to that I used the second option to execute packages in parallel.
The steps followed are
Create Job for each Package.
Add another job and start each of those created jobs using it as shown in the below image.
It will start all those three jobs in parallel. Since we created those three jobs to execute packages, those packages will execute in parallel.