Devart Forums

Shalex,

1 -> Yes
2-> the real name is Perfil_202001

Can it be the version I have installed ?, I currently have version 1.6.643

And I can't upgrade the SISS Data Flow to a more current version, because I also have separately installed "dotConnect for Salesforce v.3.3.696" and when I upgrade the SISS Data Flow, dotconnect stops working, due to that my license cannot use that version.

I have a data extension, which appears in the list of objects and to which I can make queries in the query editor, but when I execute the ETL an error is generated, indicating that the object does not exist.

Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0x0 at Data Flow Task, Devart ExactTarget Source: Failed to get the schema from data source. Detailed error messages are: Object 'xxxxx' does not exist.
Error: 0xC0047062 at Data Flow Task, Devart ExactTarget Source [2]: System.InvalidOperationException: Failed to get the schema from data source. Detailed error messages are: Object 'xxxxx' does not exist.
   in Devart.SSIS.SqlShim.BaseComponent.AcquireSchemaTable (String CommandText, Boolean useCache)
   in Devart.SSIS.SqlShim.SourceComponent.b ()
   in Devart.SSIS.SqlShim.SourceComponent.Validate ()
   in Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate (IDTSManagedComponentWrapper100 wrapper)
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: Devart ExactTarget Source failed validation and returned error code 0x80131509.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package ".dtsx" finished: Failure.

The same error occurs in 2 instances of exacttarget from different clients

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