ExactTarget error: Data Extension does not exist
Posted: Tue 21 Jan 2020 15:05
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
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