Help get this topic noticed by sharing it on Twitter, Facebook, or email.

time out issue

time out issue - various messages - one is OLE DB provider "DBAmp.DBAmp" for linked server "salesforce" returned message "Error: INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Session timed out".

Running following query(expecting about 500000 records) Have any suggestions

Insert into dbo.Account_Staging
Select Id , Membership_ID__c,Cancel_Date__c,Name,FirstName,LastName from openquery(salesforce,

'SELECT Id , Membership_ID__c,Cancel_Date__c,Name,FirstName,LastName
FROM Account

WHERE (Cancel_Date__c)

Thanks for any help
1 person has
this problem
+1
Reply