I use the Execute Package task in my work to invoke my child packages. I use the SQL execution task to get the file location and file name for uploading the file to my tables.
As soon as I get this data, I will pass this information to my Execute Package task, where it calls my child package.
My query runs 2 input files that need to be uploaded to my tables.
For example, suppose file1.csv and file2.csv are loaded. Therefore, when file1.csv loads, if there is any error in my child package, my child package fails and my parent package also works. This should not be so; if my file1.csv does not load, my child package and parent package should not fail and should continue loading file2.csv .
To do this, I tried to change the value of the System Propagate variable to false to complete the Package task for the On Error event, but I could not solve the problem.
source share