Salesforce connector - SQLite Error

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
valthor
Posts: 6
Joined: Fri 25 Aug 2017 00:34

Salesforce connector - SQLite Error

Post by valthor » Tue 20 Feb 2018 10:29

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.

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

Re: Salesforce connector - SQLite Error

Post by Shalex » Wed 21 Feb 2018 13:01

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).

valthor
Posts: 6
Joined: Fri 25 Aug 2017 00:34

Re: Salesforce connector - SQLite Error

Post by valthor » Fri 23 Feb 2018 11:52

The product is : SSIS Data Flow Components for Salesforce

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

Nothing else

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Salesforce connector - SQLite Error

Post by Pinturiccio » Tue 27 Feb 2018 11:19

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.?

Post Reply