topic Re: Syntax error while pipeline copies from onew Wharehouse to another in Pipelines

Syntax error while pipeline copies from onew Wharehouse to another

DenisLux — Fri, 30 Jun 2023 12:59:08 GMT

When attempting to copy data from one Warehouse to another using a pipeline, an error occurs if a new table needs to be created in the destination Warehouse:

ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Incorrect syntax near ')'.'

No such error occurs when copying data into an existing table.

Can someone help to overcome this issues?

Thank you!

Re: Syntax error while pipeline copies from onew Wharehouse to another

GraceGu — Tue, 04 Jul 2023 01:17:53 GMT

Thanks for reporting the issue, it is tracked as internal bug. Will share update.

Re: Syntax error while pipeline copies from onew Wharehouse to another

GraceGu — Thu, 06 Jul 2023 03:39:03 GMT

Tentative ETA of the fix available is end of July.

Re: Syntax error while pipeline copies from onew Wharehouse to another

DenisLux — Thu, 06 Jul 2023 07:11:32 GMT

Thanks for keeping up to date!