The package path referenced an object that cannot be found

LeVette Alexander
LeVette Alexander used Ask the Experts™
on
Error when executing my SSIS package and passing the parameters.  I've executed from the 32 bit and 64 bit paths.  

DTEXEC.EXE /F "C:\SSIS\Testing.dtsx" /SET \Package.Variables[User::Concept].Properties[Value];"010" /SET \Package.Variables[User::ID].Properties[Value];"21603" /SET \Package.Variables[User::BaseID].Properties[Value];"143"



Warning: 2014-11-17 14:54:16.30
   Code: 0x80012017
   Source: Testing
   Description: The package path referenced an object that cannot be found: "\Pa
ckage.Variables[User::Concept].Properties[Value]". This occurs when an attempt
 is made to resolve a package path to an object that cannot be found.
End Warning
DTExec: Could not set \Package.Variables[User::Concept].Properties[Value] valu
e to 010.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Check that your variable is in scope where it is used.
Check also that you are using it correctly - variable names are case-sensitive.
You can also try putting paths in quotes ( " ).
Finally, DTEXEC must be running as a user: check that that user can see the file you're trying to use.

hth

Mike
LeVette AlexanderDatabase Administrator

Author

Commented:
Ive doubled checked everything.  The package variables are within the scope, variable names are set correctly, paths are in quotes and I'm running as the service account.


Same error

 Description: The package path referenced an object that cannot be found: "\Pa
ckage.Variables[User::Concept].Properties[Value]". This occurs when an attempt
 is made to resolve a package path to an object that cannot be found.
End Warning
DTExec: Could not set \Package.Variables[User::Concept].Properties[Value] valu
e to 010.
LeVette AlexanderDatabase Administrator

Author

Commented:
I removed everything the variables and now I'm just running the below.  

DTExec.exe /F "C:\Pathtopackage\packagename.dtsx"

Now, it's complaining that it's unable to acquire connection  "XX" -  I set this package up using ado.net connection and I'm using windows auth.  Any  suggestions?
LeVette AlexanderDatabase Administrator

Author

Commented:
With a little more research I was able to complete the execution.  Thank you for pointing me in the right direction.

Commented:
So what _was_ the answer to the problem? Please post it for us, so that everyone here can learn.

Mike

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial