dotConnect for Salesforce - error when obtaining field type time (time)

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
claudio.silva
Posts: 1
Joined: Wed 08 May 2019 17:14

dotConnect for Salesforce - error when obtaining field type time (time)

Post by claudio.silva » Wed 08 May 2019 18:09

I have a custom object in salesforce, which has a time-type field and when I write the sql statement in the editor and preview it, it displays without problems, but when I run the module it indicates conversion error

If I delete the field of the query, it runs without problem, but when adding it fails

Error: 0xC0047062 at Genera ASC, Devart Salesforce Source [12]: System.InvalidCastException: The specified conversion is not valid.
en Devart.SSIS.Salesforce.SalesforceSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
en Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)
Error: 0xC0047038 at Genera ASC, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Devart Salesforce Source returned error code 0x80004002. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

Any idea how to solve it?

regards

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

Re: dotConnect for Salesforce - error when obtaining field type time (time)

Post by Shalex » Mon 13 May 2019 16:24

1. Please send us a test package so that we can reproduce the issue and investigate it in our environment.

2. Specify the steps we should follow to recreate your scenario:
a) the names and exact types of fields in Salesforce
b) the names and exact types of fields in the destination

Post Reply