June 13, 2011 at 6:34 am
I have a package (PkgA) that calls another package (PkgB).
PkgA and PkgB are both in the same directory on the filing system.
When I run PkgA manually ( click on the package and execute) it has no problem finding and running PkgB.
when i run PkgA from within an agent job, the job fails, telling me it cannot find PkgB or does not have permisisons.
I know the agent account has permissions on both packages and the directory they are stored in.
I fixed the problem by ensuring the connection in PkgA to PkgB is a fully qualified path (D:\Dir\Dir\Pkg\PkgB.dtsx).
I dont like having a Fully Qualified Path but its the only way i can get the package sucessfully run from an agent job.
Is there any way i can call PkgB without using the FullyQualified Path, seeing as they are both in the same directory?
June 14, 2011 at 2:41 pm
winston Smith (6/13/2011)
Is there any way i can call PkgB without using the FullyQualified Path, seeing as they are both in the same directory?
Not that I'm aware of...hopefully soon.
In the meantime, you could store the package path in a variable and then use a Package Configuration to set the value before the package runs. Then you'd just need to set the filepath on the Execute Package task to use an expression that joins your package path variable. That might make it a bit more manageable.
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply