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.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-08-29 : 05:33:46
|
| Dear all,we have Created SSIS Package(SQL SERVER 2008)this my main package My Main Package is having 3 child Packages(Execute Package Task)MY MAIN and Child Packages are Having PAssword.Whenever i am executing packages Manually successfully executing fineWhenever i am executing this packages through SQL Agent i am facing this error 0*8007005while loading the Package file "Packages.dtsx " Access Deniedwhenever i am creating Steps through (SQL AGENT )i have passed my MAIN package Password only .so how to Pass the Child PAckge PAssword using SSIS Variable or Any other way to Resolve the issue |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-29 : 13:18:36
|
| you need to add password as a configurable item in child packages and link them to parent package variable via parent package variable config type. then add parent package variable as a config item in it and set value through SQL agent job step while configuring------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2012-08-31 : 01:26:29
|
| Dear visakh,can u suggest me how to do all these configurations.and how to set these values to sql agent job Thanks for ur reply. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Pkg Password Passing Through Varible