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
SolvedPrivate

The package path referenced an object that cannot be found

Posted on 2014-11-17
5
39 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
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

840 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