InvalidCastException on SSIS Package Execution

[twong]

I'm receiving the following error message when executing my SSIS Package (dtsx) on my 2014 SQL Server Instance

Code: Select all

				System.InvalidCastException: [A]Devart.SSIS.Salesforce.SalesforceConnectionManager cannot be cast to [B]Devart.SSIS.Salesforce.SalesforceConnectionManager. 
					Type A originates from 'Devart.SSIS.Salesforce.120, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 
						'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Devart.SSIS.Salesforce.120\v4.0_1.0.0.0__09af7300eec23701\Devart.SSIS.Salesforce.120.dll'. 
					Type B originates from 'Devart.SSIS.Salesforce.110, Version=1.0.0.1, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 
						'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Devart.SSIS.Salesforce.110\v4.0_1.0.0.1__09af7300eec23701\Devart.SSIS.Salesforce.110.dll'.

My SSIS project is targeted to SQL Server 2012 which means the Devart Lookup controls I'm using are the 110 version. If I change the target to "SQL Server 2014", the controls are then the 120 version and I don't have this casting issue anymore. However, I have 30 other SSIS projects that are running into this issue and I don't want to manually upgrade and recreate every package.

Is there a better/easier way to upgrade the controls?

[Shalex]

My SSIS project is targeted to SQL Server 2012 which means the Devart Lookup controls I'm using are the 110 version. If I change the target to "SQL Server 2014", the controls are then the 120 version and I don't have this casting issue anymore.

That is a recommended fix.

However, I have 30 other SSIS projects that are running into this issue and I don't want to manually upgrade and recreate every package.

Is there a better/easier way to upgrade the controls?

Unfortunately, there is no another way to fix the issue.