August 27, 2010 at 12:47 pm
I have a parent and child package. Both are stored on the file system and both are password protected. My problem is that when I call the child package from the parent using execute package task, I get prompted for the child package's password. Now the PackagePassword property of the Execute Package Task is supposed to take care of that. But for some reason the password stored in the Execute Package Task is not getting passed to the child package. Can anyone help?
August 27, 2010 at 3:59 pm
PackagePassword property of the Execute Package Task is supposed to take care of that
I'm assuming you are refering to and have already tried this?
Password
If the child package is password protected, provide the password for the child package, or click the ellipsis button (…) and create a new password for the child package.
http://msdn.microsoft.com/en-us/library/ms188104.aspx
Can you copy and paste the error message?
August 30, 2010 at 7:00 am
brucla,
"I'm assuming you are referring to and have already tried this?"
If the child package is password protected, provide the password for the child package, or click the ellipsis button (…) and create a new password for the child package.
You are correct. That is precisely what I tried. I am not getting an error message, however. But I am being prompted for the child packages password at runtime. So it would appear that the password property mentioned in the above quote is not working.
August 30, 2010 at 10:01 am
Just for fun, I tried deploying my packages and running them from sql server agent -> jobs. It worked fine. No prompts. I guess it is only an issue when running in visual studio. Since you would only run a package in visual studio during development and testing, the prompting is acceptable.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply