I am trying to schedule the execution of a package through sql agent. The package call child packages that are falling over because the protection level of the child package is set to EncryptSensitiveWithPasswo
I believe you can pass the password through dtexec but that is not a desirable solution because I would need to hardcode the password in the job. Also I would need to setup a xp_cmdshell proxy for the user I am running the job as to run dtexec or make
that user sysadmin which I am not keen on either.
I have given a tip that I could use a package template - (see http://support.microsoft.com/kb/918760
does anyone know if this would help my situation and what exactly to do (a pointer to some doco would be fab)