SolvedPrivate

The package path referenced an object that cannot be found

Posted on 2014-11-17
5
44 Views
Last Modified: 2016-02-11
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.
0
Comment
Question by:LeVette Alexander
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 500 total points
ID: 40449672
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
 

Author Comment

by:LeVette Alexander
ID: 40449772
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
 

Author Comment

by:LeVette Alexander
ID: 40449905
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
 

Author Closing Comment

by:LeVette Alexander
ID: 40450356
With a little more research I was able to complete the execution.  Thank you for pointing me in the right direction.
0
 
LVL 16

Expert Comment

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

Mike
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Determining the an SCCM package name from the Package ID
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question