I had a child package AAA
The ProtectLevel of AAA is "EncryptAllWithPassword" and PackagePassword is "passtest"
now I put a Execute Package Task on Control Flow TAB of Package BBB
in this task I want to Execute package AAA,after set Password "passtest" of Execute Package Task ,I execute package in command line
DTExec.exe /F BBB.dtsx
I get error message,
can't decrypt package AAA
Where can I set the PackagePassword of AAA in Execute Package Task.
i haven't attempted to do this, but have you tried using a parent variable? http://msdn2.microsoft.com/en-us/library/ms345179.aspx|||I didn't use any parent variable in child package,
the password protected child package can't be executed in parent package,how can I set the child's password in parent package?
|||i understand that you aren't now using a parent variable. i am suggesting that you try using a parent variable and set it to the the child package password. then you should be able to use this variable when the parent package executes the child package.|||ycjj wrote:
I didn't use any parent variable in child package,
the password protected child package can't be executed in parent package,how can I set the child's password in parent package?
thank you for the answer.
I will try it.
|||thank you!
you are right, it works after I set the parent variable
No comments:
Post a Comment