Page 1 of 1

Salesforce connector - SQLite Error

Posted: Tue 20 Feb 2018 10:29
by valthor
I've been using the SSIS connector to Salesforce and it's working well until now.

When I now use a Salesforce destination, pick an object to select from and click 'preview', I now _always_ get an error: SQLite error, and no preview is shown. Getting data from the objects during runtime still works though.

Re: Salesforce connector - SQLite Error

Posted: Wed 21 Feb 2018 13:01
by Shalex
1. Is the name of your product "SSIS Data Flow Components for Salesforce" (devartssis.exe) or "dotConnect Salesforce Professional" (dcsalesforce32pro.exe)?

2. Specify the exact text of the error and its full stack trace (if any).

Re: Salesforce connector - SQLite Error

Posted: Fri 23 Feb 2018 11:52
by valthor
The product is : SSIS Data Flow Components for Salesforce

The only error message displayed is a popup dialog with: SQLite Error

Nothing else

Re: Salesforce connector - SQLite Error

Posted: Tue 27 Feb 2018 11:19
by Pinturiccio
We could not reproduce the issue. Please provide the following information:
1. The version of SSIS Data Flow Components for Salesforce.
2. SQL query text that you use in the Salesforce Source component.
3. Describe the steps you have performed. What source and destination are used, on which step does the error occur, etc.?