April 27, 2015 at 3:33 pm
An SSIS project deployed to the production environment is currently failing validation and execution with the following messages
The component metadata for "CDC Source, clsid {874F7595-FB5F-40FF-96AF-FBFF8250E3EF}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
The component metadata for "CDC Splitter, clsid {874F7595-FB5F-40FF-96AF-FBFF8250E3EF}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
The production environment is running
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
which is SP2. The same project is validated and executed without any errors on dev which is running
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
which is also SP2.
The only difference between dev and production is the fact that dev environment also has SSDT for Visual Studio 2012 and 2013 installed.
What would cause this behavior on the production environment?
April 29, 2015 at 1:16 pm
It turned out that SSIS was at SP1 while SQL Server was at SP2. So after upgrading SSIS to SP2 and installing Data tools for Visual Studio 2012 the problem has gone away.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply