Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2012-10-19 : 09:20:46
|
| I'm trying to deploy my first SSIS package. It all seems to go fine apart from it not running (even though it does from my machine). The error is below. Anyone know how to sort this?After some looking around I suspect that it's due to my machine being 32 bit but the server being 64 bit. From what I can see of this though the problem seems to be with the ADO.NET connection so I am not sure which connection I should be using.I've also noticed that the SQL Server version is 10.0.4000 but the SSIS version is 10.0.1600, I know there is a bug that has been resolved for later versions but I'm not sure how to find out my SSIS version (I suspect it's not the SP1 version but how can I be sure?) and what are the chances this will solve my problemcheerssteveMessageExecuted as user: MyServer\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:51:02 Error: 2012-10-19 11:51:03.18 Code: 0xC0047062 Source: Copy data to Reporting Copy data to Reporting (AF Reporting [16]) Description: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of component "AF Reporting" (16) 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: 2012-10-19 11:51:03.18 Code: 0xC004801F Source: Copy data to Reporting Copy data to Reporting (SSIS.Pipeline) Description: The component metadata for "component "AF Reporting" (16)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error Error: 2012-10-19 11:51:03.33 Code: 0xC004801F Source: Copy data to Reporting SSIS.Pipeline Description: The component metadata for "component "AF Reporting" (16)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error Error: 2012-10-19 11:51:03.38 Code: 0xC0048021 Source: Copy data to Reporting AF Reporting [16] 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: 2012-10-19 11:51:03.38 Code: 0xC0047017 Source: Copy data to Reporting SSIS.Pipeline Description: component "AF Reporting" (16) failed validation and returned error code 0xC0048021. End Error Error: 2012-10-19 11:51:03.38 Code: 0xC004700C Source: Copy data to Reporting SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-10-19 11:51:03.38 Code: 0xC0024107 Source: Copy data to Reporting Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:51:02 Finished: 11:51:03 Elapsed: 0.672 seconds. The package execution failed. The step failed.-----------Insanity: doing the same thing over and over again and expecting different results. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-19 : 22:55:56
|
| looks like your dev ssis version is newer compared to server version.whats the type of this component (AF Reporting)?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS Noob