I created a config type 'Parent package variable' (ParentPackKey) in a parent
package and successfully passed it to a child package. I successfully
performed an INSERT into a table. The correct ParentPackKey appeared in the
table.

However this error appears:
"Validation error. Update <<PackageName>> : Failed to lock variable
"User::ParentPackKey" for read access with error 0xC0010001 "The variable
cannot be found. This occurs when an attempt is made to retrieve a variable
from the Variables collection on a container during execution of the package,
and the variable is not there. The variable name may have changed or the
variable is not being created.". "

The "ParentPackKey" was created in the Variables window in both the Master
and Child packages.

What's going on??
--
Thanks in advance
GH

Additionally This warning appears:

"Warning: 0x8001201A at <<package name>>: Configuration from a parent
variable "ParentPackKey" did not occur because there was no parent variable
collection.
"

The 'Parent Variables Collection" is the variables listed in the "Variables"
window on the parent package page .. correct or am I missing something.
--
GH


"GH" wrote:

Hello,

I'd like to know how you insert into table from the local variable.

I get the local variable from a parent package variable by using the parent
variable:

Right click the child package->Package configuration and map the parent
variable to a local variable..

Then I used a Execute sql task package to insert into the table by using a
SP while mapping the local variable to a SP input parmater. You may want to
refer to the following articl for more details:

http://www.sqlis.com/default.aspx?58

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,

Thanks for the reply.

This is the process:

1.) In the parent package the ParentPackKey is determined by the following:
SELECT MAX(PackageKey) AS ParentPackKey
FROM dbo.ProcessHistory_Package
WHERE PackageName = @PackageName AND Start = @Start

2.) In package Configurations I have created a Parent Package Variable
ConfigurationString = 'ParentPackKey', TargetObject = 'ParentPackKey',
TargetProperty = 'Value'. And the ParentPackKey is added as a 'user
variable' with a 'package' scope to the variables window.

3.) The next step in the Parent Package is an ExecutePackageTask which
calls the Child package.

4.) The Child Package calls an Execute SQL Task which insets the value of
@ParentPackKey into the history table.

The task completes however the following messages are returned:

Information: 0x40016042 at <<packagename>>: The package is attempting to
configure from the parent variable "ParentPackKey".
Warning: 0x8001201A at <<packagename>>: Configuration from a parent variable
"ParentPackKey" did not occur because there was no parent variable collection.


Where/What is the 'Parent Variable Collection'

--
Thanks in advance
GH


""privatenews"" wrote:

Hello,

Thank you for your update.

Based on my test, it is not necessary to configure "package configurations"
on parent package. Instead you shall configure "package configuration" on
child package. For example, you have a parentpackkey variable in parent
package, you shall configure the following:

configuration name = name
configuration type= parent package variable
configuration string= parentpackkey
Target object = [local variable name]

You could then use local variable directly in your Execute SQL Task.

If anything is unclear, please let me know. Have a great day!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.