Im using SSIS 2019 and VS 2019
The data scientist gave me a project with multiple packages and when i use VS all the packages run fine
However when i deploy the project to the SSIS catalog and create a new job to run the packages in a certain sequence; i get the error attached.
The Execute SQL Task runs fine but it fails when it moved to the Data Flow Task 1 with the error in the attached document.
I read that it might be linked to the protection level as on the project level the security is set to EncryptSensitiveWithUserKey