Issue on SSIS Devart Salesforce Lookup

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
ssi
Posts: 2
Joined: Wed 20 Aug 2014 14:28

Issue on SSIS Devart Salesforce Lookup

Post by ssi » Wed 20 Aug 2014 14:38

Hello,

I have an issue when I want to use the toolbox 'Devart Salesforce Lookup'. When I edit it I have the message: Value of 'null' is not valid for 'stream'.

Program Location:
at System.Drawing.Icon..ctor(Stream stream, Int32 width, Int32 height)
at System.Drawing.Icon..ctor(Stream stream)
at Devart.SSIS.Salesforce.Design.e..ctor(IServiceProvider A_0, IDTSComponentMetaData100 A_1, Connections A_2)
at Devart.SSIS.Salesforce.Design.SalesforceLookupComponentUI.Edit(IWin32Window parentWindow, Variables vars, Connections cons)
at Microsoft.DataTransformationServices.Design.DtsComponentDesigner.StartComponentUI(Boolean startGenericUI)

With:
Devart dotConnect for Salesforce Professinal version 2.4.436.0
Visual Studio 2008 version 9.0.30729.4462 QFE
Microsoft .NET Framework version 3.5 SP1

Regards,

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Issue on SSIS Devart Salesforce Lookup

Post by Shalex » Thu 21 Aug 2014 15:21

ssi wrote:When I edit it I have the message: Value of 'null' is not valid for 'stream'.
We have reproduced the problem and will notify you when it is fixed.
As a workaround, please use the "Show Advanced Editor" (instead of "Edit") context menu option of Devart Salesforce Lookup.

JIC: the Devart Salesforce Lookup component includes a basic functionality (without caching) of Microsoft's Lookup component (http://technet.microsoft.com/en-us/libr ... 41821.aspx). Just create a new (or use existing) Data Flow Task, add and set Devart Salesforce Source, link it to a new Devart Salesforce Lookup and use it to access additional information in a related table that is based on values in common columns to make a lookup transformation.

ssi
Posts: 2
Joined: Wed 20 Aug 2014 14:28

Re: Issue on SSIS Devart Salesforce Lookup

Post by ssi » Fri 22 Aug 2014 07:36

Thank you for help.
Have a nice day.

Regards.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Issue on SSIS Devart Salesforce Lookup

Post by Shalex » Thu 04 Sep 2014 14:54

The bug with throwing "Value of 'null' is not valid for 'stream'" error when opening editor of Devart Salesforce Lookup is fixed in the new (2.4.460) build of dotConnect for Salesforce.

It can be downloaded from http://www.devart.com/dotconnect/salesf ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=38&t=30321.

Post Reply