I run into the following 2 exceptions when I execute a package on SQL Server 2005 64 bit machine. The package fails when
SQL Server version is 9.0.3310 which is a production box. I have tested it on 3 others development boxes with SQL version 9.0.1399,
9.0.3315 & 9.0.4053 and the package executes fine. I am unable to make a determination if this issue is related to SQL versions or a bug in the package design. I would like to understand the exception better before I request an
SP3 & patches installed to upgrade it to version 9.0.4053 on the production box.
I have scheduled jobs to run these packages and we are trying to locate Excel files on a drive using For Each Loop Enumerator.
The packages are configured to use configuration files. Please note the destination directory does have the Excel files we are looking for.
Source: Well_Test_Package Description: The package path referenced an object that cannot be found: "\Package\Daily Alloc Spread Sheet Foreach Loop Container.ForEachEnumerator.Properties[Directory]". This occurs when an attempt is made to resolve a package
path to an object that cannot be found. End Warning Warning: 2010-08-31 00:41:13.66 Code: 0x80012017
Source: Well_Test_Package Description: The package path referenced an object that ca
View Complete Post