title: SSIS error during Job execution
body: <p>I have a job created to run a SSIS package.  I had problems with package security for a while, but managed to set the package password correctly and that error disappeared.  This next error was not occurring last night, but today I can't seem to get rid of it.  If I run the package independently via BIDS or by connecting to my Integration Services it runs successfully.</p>
  
  <p>Any ideas what would cause this error when it is run as a job, but not when run as a package?</p>
  
  <pre><code>Date        7/7/2010 2:10:59 PM
  Log     Job History (Identipass Data Transfer)
  
  Step ID     1
  Server      BETTY
  Job Name        Identipass Data Transfer
  Step Name       SSIS Transfer Data
  Duration        00:00:02
  Sql Severity        0
  Sql Message ID      0
  Operator Emailed        
  Operator Net sent       
  Operator Paged      
  Retries Attempted       0
  
  Message
  Executed as user: AD\theusername. 
  Microsoft (R) SQL Server Execute Package Utility  
  Version 10.0.2531.0 for 64-bit  
  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    
  Started:  2:10:59 PM  
  
  Error: 2010-07-07 14:10:59.44     
  Code: 0xC0047062     
  Source: Data Flow Task Data Flow Task (ADO NET Destination [40])     
  Description: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: 
  The version of component "ADO NET Destination" (40) is not compatible with this version of the DataFlow.  
  [[The version or pipeline version or both for the specified component is higher than the current version.  
  This package was probably created on a new version of DTS or the component than is installed on the current PC.]]     
  at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)  
  End Error  
  
  Error: 2010-07-07 14:10:59.44     
  Code: 0xC004801F     
  Source: Data Flow Task Data Flow Task (SSIS.Pipeline)     
  Description: The component metadata for "component "ADO NET Destination" (40)" could not be upgraded to the newer version of the component. 
  The PerformUpgrade method failed.  
  End Error  
  
  Error: 2010-07-07 14:10:59.46     
  Code: 0xC004801F     
  Source: Data Flow Task SSIS.Pipeline     
  Description: The component metadata for "component "ADO NET Destination" (40)" could not be upgraded to the newer version of the component. 
  The PerformUpgrade method failed.  
  End Error  
  
  Error: 2010-07-07 14:10:59.54     
  Code: 0xC0048021     
  Source: Data Flow Task ADO NET Destination [40]     
  Description: The component is missing, not registered, not upgradeable, or missing required interfaces. 
  The contact information for this component is "Writes to a database using ADO.NET provider.;
  Microsoft Corporation; Microsoft SqlServer v10; ? 
  2007 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1".  
  End Error  
  
  Error: 2010-07-07 14:10:59.54     
  Code: 0xC0047017     
  Source: Data Flow Task SSIS.Pipeline     
  Description: component "ADO NET Destination" (40) failed validation and returned error code 0xC0048021.  
  End Error  
  
  Error: 2010-07-07 14:10:59.54     
  Code: 0xC004700C     
  Source: Data Flow Task SSIS.Pipeline     
  Description: One or more component failed validation.  
  End Error  
  
  Error: 2010-07-07 14:10:59.54     
  Code: 0xC0024107     
  Source: Data Flow Task      
  Description: There were errors during task validation.  
  End Error  
  
  DTExec: The package execution returned DTSER_FAILURE (1).  
  
  Started:  2:10:59 PM  
  Finished: 2:10:59 PM  
  Elapsed:  0.422 seconds.  
  The package execution failed.  
  The step failed.
  </code></pre>