Unable to open package with Devart SSIS Data Flow Components for Salesforce

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
adriens
Posts: 3
Joined: Wed 11 May 2016 14:20

Unable to open package with Devart SSIS Data Flow Components for Salesforce

Post by adriens » Thu 16 Mar 2017 17:30

Hi,

we did install Devart SSIS Data Flow Components for Salesforce on our server (version 1.5.287), and since then we are not able to open previous packages made with dotConnect for Salesforce SSIS Edition (version 2.4.658) . Is there any compatibility issue ? Or did we forgot to do something like erase local cache ?

When we use the dotConnect for Salesforce Professional Edition trial version, we can edit our packages properly.

We are using SQL Server 2016.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Unable to open package with Devart SSIS Data Flow Components for Salesforce

Post by Pinturiccio » Fri 17 Mar 2017 16:47

The reason of the error is that two different versions of the same assembly Devart.Data.Salesforce.dll are used at the same time.

dotConnect for Salesforce 2.4.658 was released on 18 June, 2015. SSIS Data Flow Components 1.5.287 were released on 1 September, 2016. These products use different Devart.Data.Salesforce.dll assembly versions. Uninstall both products and then install only one of them.

We recommend using SSIS Data Flow Components 1.5.287, because it was released almost a year later than dotConnect for Salesforce 2.4.658.

You can also install dotConnect for Salesforce and SSIS Data Flow Components for Salesforce versions that were released on the same date on one computer. For example, you can install SSIS Data Flow Components for Salesforce 1.5.287 and dotConnect for Salesforce 3.1.97 on the same computer because they use the same version of the assembly. Since both products place the same assembly of the same version to the GAC, the assembly of a product that was installed later is used.

adriens
Posts: 3
Joined: Wed 11 May 2016 14:20

Re: Unable to open package with Devart SSIS Data Flow Components for Salesforce

Post by adriens » Tue 04 Apr 2017 14:47

Hi,

thank you for your answer.
We did perform a clean install on our server. After checking the GAC directory, We tried our latest version available (1.5.287) and the latest trial version (1.5.420) . In both cases, we had the same error :

"The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails."

As I said on my previous post, with the latest trial version of dotConnect for Salesforce Professional Edition, it works fine.

Is there any difference between those two products ?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Unable to open package with Devart SSIS Data Flow Components for Salesforce

Post by Pinturiccio » Wed 05 Apr 2017 15:29

We have answered you via e-mail.

Post Reply