SolvedPrivate

The package path referenced an object that cannot be found

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

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

679 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