question

nightmareivy avatar image
nightmareivy asked

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
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image
JohnM answered
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?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Also resolved on the other forum...
0 Likes 0 ·
lakshmiprathyusha avatar image
lakshmiprathyusha answered
Hi, Set the property of User::ReportID varaible :"IncludeInDebugDump" to "False" and try if it works?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.