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 fine
Whenever i am executing this packages through SQL Agent i am facing
this error 0*8007005
while loading the Package file
"Packages.dtsx " Access Denied
whenever 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 MVP
http://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