I wrote a python script to create partitions. When I use ssis package to run the python file, it was successful -> created the partition. But when I use sql Agentjob to set up a schedule using SSIS catalog, when check log of ssis catalog it shows and the partiton cannot be created.
“The process exit code was “1” while the expected was “0” Error “
Can anyone help me to solve that? Thank you in advance.
Note: I am using SQL2019.
I try to hardcode was 0 but it is not successfully.