Page 1 of 1

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

Posted: Wed 08 May 2019 18:09
by claudio.silva
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

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

Posted: Mon 13 May 2019 16:24
by Shalex
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