I need to pass a package password for the SSIS Package task. I can do this in DTEXec but how do I this in Visual Cron?

Either if you use the Credential for the whole SQL connection or maybe you can supply it in a configuration file?

---

DTSExec has a command line option

DTExec /De password /F PackageFile

Thanks for pointing that out. We will add a password option for the package.

1. Is anything else needed here?
2. Is the password for package option only for packages on files or general?

---

There is a required field on t he package called "ProtectionLevel". This may not be an issue with a package deployed to SQL Server as they can assume the user is already authenticated but it seems to be an issue with file based execution. I am currently calling DTExec myself and passing in the password but I would be glad to test any fix you apply.

Please try the latest beta from the beta forum. We have added a password field but need your help to verify the change. Thank you.

---