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
------------------------------
can't get data from Salesforce with dotConnector
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.
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.
Re: can't get data from Salesforce with dotConnector
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.
Re: can't get data from Salesforce with dotConnector
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 .
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 .