Azure Synapse Analytics copy data activity

Zaid Mhamud 0 Reputation points
2023-04-11T13:30:27.92+00:00

Hi All, I am trying to copy data from cosmos no sql to Azure SQL and the source query looks like valid, but it me gives me this error.

{
    "errorCode": "2200",
    "message": "ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property 'collectionName' is invalid: 'The required property is not specified.\r\nParameter name: collectionName'.,Source=,''Type=System.ArgumentException,Message=The required property is not specified.\r\nParameter name: collectionName,Source=Microsoft.DataTransfer.Common,'",
    "failureType": "UserError",
    "target": "employee_forward",
    "details": []
}
@concat('select * from emplyee c where c.createdDate >=''' ,variables('maximumdate'),'''')
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,443 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2023-04-11T19:55:11.5033333+00:00

    Hi @Zaid Mhamud , Thanks for the question and using MS Q&A platform. I did a quick test that I think the dynamic expression attached script should work dynamicexpression.txt

    It will generate the query as below , which is valid .

    User's image

    Let me know how it goes. Thanks
    Himanshu

    Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.