x

The package path referenced an object that cannot be found

I'm getting the error below, just to preface...I do have all my package variables in the package level/scope, could there be another reason as to why this is occurring or other things i should try first?

dtexec /f "D:\SSISPackages\TEST_REPORT.dtsx" /set "\package.variables[User::ReportID].Properties.Value";"95E56F3A-DBEF-4FA1-B3E9-92A4BCB15E42"


Microsoft (R) SQL Server Execute Package Utility
Version 10.50.2500.0 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
NULL
Started:  10:54:02 AM
Warning: 2012-09-20 10:54:02.72
   Code: 0x80012017
   Source: TEST_REPORT 
   Description: The package path referenced an object that cannot be found:
"\package.variables[User::ReportID].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::ReportID].Properties.Value 
value to 6A48D31E-3356-41C2-8BA7-A4C73869D5F1.
Started:  10:54:02 AM
Finished: 10:54:02 AM
Elapsed:  0.468 seconds
NULL
more ▼

asked Sep 20, 2012 at 03:20 PM in Default

nightmareivy gravatar image

nightmareivy
20 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

It appears that someone posted a very similar question today over at MSDN: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9cfc05f7-b9b8-47d0-a5a1-4c80afb07b0d

Have you tried their solution? Are you executing the command in the same manner?

more ▼

answered Sep 20, 2012 at 05:55 PM

JohnM gravatar image

JohnM
6.6k 1 3 7

Also resolved on the other forum...
Sep 21, 2012 at 09:43 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

Hi,

Set the property of User::ReportID varaible :"IncludeInDebugDump" to "False"

and try if it works?
more ▼

answered Jul 15, 2013 at 12:36 PM

lakshmiprathyusha gravatar image

lakshmiprathyusha
0

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x929

asked: Sep 20, 2012 at 03:20 PM

Seen: 1780 times

Last Updated: Jul 15, 2013 at 12:36 PM