asked
Child package failed which is being executed by scheduled parent package
We are facing an issue with ssis package that has Oracle connection. Issue discrimination is as follows. 1. Package failing if we keep protection level to DonSaveSensitive 2. Package is succeeded If we keep protection to EncryptSensitiveWithUser but failing the package when we schedule it using Windows task scheduler/Control M. 3. Package is succeeded with schedule task if we make production level to EncriptSensitiveWithPassword and pass /DECRYPT Password as parameter to DTEXEC.EXE which execute the package through batch file. 4. The same package getting failed if package is being executed by scheduled by (Windows Task scheduler/Control M) parent package even though if we pass /DECRYPT Password as parameter to DTEXEC.EXE in batch file
17 People are following this question.
