The package path referenced an object that cannot be found

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.
LeVette AlexanderDatabase AdministratorAsked:
Who is Participating?
 
DcpKingConnect With a Mentor 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
0
 
LeVette AlexanderDatabase AdministratorAuthor 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.
0
 
LeVette AlexanderDatabase AdministratorAuthor 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?
0
 
LeVette AlexanderDatabase AdministratorAuthor Commented:
With a little more research I was able to complete the execution.  Thank you for pointing me in the right direction.
0
 
DcpKingCommented:
So what _was_ the answer to the problem? Please post it for us, so that everyone here can learn.

Mike
0
All Courses

From novice to tech pro — start learning today.