Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS - Help with execute package task

Author  Topic 

ddiamond
Starting Member

4 Posts

Posted - 2010-08-27 : 13:36:31
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? I'm desperate.

ddiamond
Starting Member

4 Posts

Posted - 2010-08-30 : 12:06:18
I tried deploying my package and running it from a sql agent job. It worked perfectly. So I'd have to conclude that this is only an issue when running a package in debug mode through in visual studio. I can live with that.
Go to Top of Page
   

- Advertisement -