title: SQL Server Agent error - Connection "DatabaseName" is not found?
body: <p>Some modifications were made to an SSIS package and I can't seem to figure out what is wrong. The SQL server agent job which involves execution of one of these packages was running fine until a couple of days ago. The error I am seeing is this...</p>
  
  <blockquote>
    <p>Executed as user: domainname\serviceaccount. ... for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  4:47:33 PM  Error: 2010-07-07 16:47:34.09     Code: 0xC001000E     Source: PackageNAME Description: The connection "DB.NAME" is not found. This error is thrown by Connections collection when the specific connection element is not found.  End Error  Warning: 2010-07-07 16:47:34.09     Code: 0x8001F02F     Source: PackageNAME Description: Cannot resolve a package path to an object in the package ".Connections[DB.NAME].Properties[ConnectionString]". Verify that the package path is valid.  End Warning  Warning: 2010-07-07 16:47:34.09     Code: 0x80012017     Source: PackageNAME Description: The package path referenced an object that cannot be found: "\Package.Connections[DB.NAME].Properties[ConnectionString]". This occurs when an attempt is made to resolve a package ...  The package executed successf...  The step succeeded.</p>
  </blockquote>
  
  <p>I did not get any alerts that the job had an error because as the last line suggested, the step succeeded. Because of this, the job did not run "properly" for a few days and I'm scratching my head as to what may be the problem. Has anyone seen this error before?</p>