assasafras
commented
8 years ago Issue
Foreach loop Container mappings were referencing old variable names.
Solution
Made the following changes to mapping names within the Foreach Loop Container.
| Previous Name | New Name |
|---|---|
| AreaManagerName | _areaManagerName |
| AreaManagerEmail | _areaManagerEmail |
| ManagerEmail | _managerEmail |
| intRptYear | _intRptYear |
| intRptMonth | _intRptMonth |
| strReportMonth | _strReportMonth |
Package
AMSalesCommRptGen.dtsx
Message
Executed as user: FLEXIRENT\SysSQLSit. Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 4:02:44 p.m.
Error: 2016-09-30 16:02:45.64
Code: 0xC0014055
Source: Foreach Loop Container
Description: Failed to lock variable "User::AreaManagerName" for read/write 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.". End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 4:02:44 p.m.
Finished: 4:02:45 p.m.
Elapsed: 1.56 seconds. The package execution failed. The step failed.