Devart Forums

In connection manager, a connection is created and passed testing to connect to Salesforce.com (sfdc).

In Data flow, an ADO source is created to connect to sfdc to get the Contacts. the data then go to a Union All.

On execution, the following error is generated. How to fix it?


TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Data Flow Task [ADO NET Source [1]]: An error occurred executing the provided SQL command: "select * from "Contact"". INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session. Session not found, missing session key: 00Dd0000000dzLR!AR4AQBF6Ws1QpH1.Art2qYGpMlpqaN901Z7_5QADpkbkLyhHHzWf5aWWfarHjgu1yqp.52bh8C2SwoDhHIICvkU4U2Ls57pZ

Error at Data Flow Task [SSIS.Pipeline]: "component "ADO NET Source" (1)" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------

Thank you for your report. We have reproduced intermittent INVALID_SESSION_ID error in our environment. We will post here about the results of our investigation.

The INVALID_SESSION_ID error went away in our test environment and we cannot reproduce it any more. Please give us the following information:
1) is this error constant or intermittent in your environment?
2) make sure that your Internet connection is stable and cannot be the reason of the problem;
3) send us a test SSIS package. If necessary, also provide us the corresponding DDL/DML scripts for SQL Server and Salesforce.

If you are using proxy connection in your environment, please set the proxy options in your connection string (Proxy Host, Proxy Port, Proxy User, Proxy Password).

The bug with processing the situation when Session ID becomes invalid is fixed. We will post here when the corresponding build of dotConnect for Salesforce is available for download.

New build of dotConnect for Salesforce 1.2.171 is available for download!
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=24675 .