Do child and grandchild packages require passwords?

My packages are now in the filesystem. I have given the parent package a password in the properties window, saved the package and moved it to the run location.

I am using the SQL Job Agent to schedule the execution. My step command line reads:

dtexec /FILE "C:\Path\parentpackage.dtsx" /De mypass /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW

Do the the 20 or so child and grandchild packages require passwords to run this way?

Thanks,

IanO

I would say yes, they will require passwords if you are Encrypting with a password. On the children, you might want to consider using DontSaveSensitive instead, and pass in the passwords for connection manager objects via a configuration file or similar.

More importantly, have you tried it for yourself?