I am using SSIS 2008. I am trying to use the execute package task to execute a child package that is password protected. Eventhough I have entered the child's password into the execute package task's password property, I still get prompted for the child's password when I run the parent package. How can I configure the execute package task so that I am not prompted for a password?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SSIS - help with Execute Package Task
- Thread starter ddiamond
- Start date
- Thread starter
- #2
I tried deploying my package to the server and runing it with a sql agent job. It ran fine. It did not prompt for the child package's password. So it would seem that it only prompts for the password when running in visual studio. I can live with that.
- Status
Similar threads
- Locked
- Question