Call a SSIS package in another SSIS package without using the Execute package task

 All we know that we can call the SSIS package in another SSIS package using the Execute package task. I mean in a parent package we can call the child package using the Execute Package task.

Read More About: execute package task

https://bageshkumarbagi-msbi.blogspot.com/2020/09/execute-package-task-in-ssis.html

Here we are taking the example of the preview package

Read More about: Execute windows bat file from SSIS

https://bageshkumarbagi-msbi.blogspot.com/2020/09/execute-windows-bat-file-from-ssis.html

Basically in this package we are copying the files from source to destination.

Now we are creating the .bat file to execute the SSIS package.

Read more about:  Executing SSIS package from the batch file

 https://bageshkumarbagi-msbi.blogspot.com/2019/02/executing-ssis-package-from-batch-file.html

Package location

Below is the code for .bat file to execute the package.

"C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTEXEC.exe" /File "I:\ssis_example\SSIS_Package\Call_Bat_File.dtsx"

 Save the txt file with .bat

Now I am creating a new package (Parent package) and taking the execute process task and calling this .bat file.

Now providing the full path of the .bat file.

  

Package is ready to execute.

See the source folder

Destination Folder

                      

Now executing the package.

                         
It starts executing.

The package executed successfully.

Now see the destination folder.

   

Files copied successfully.

This is another way to call the Child package in the parent Package.