Azure Synapse Analytics copy data activity

Question

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'),'''')

Answer 1

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 .

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.