Azure Data Factory Not Accepting Parameter: ErrorCode=InvalidParameter,The value of the property 'tableName' is invalid: '

Question

I am trying to parameterize the sending of Data to our AzureSQLDB. I have done this many times, but for someone reason keep on getting the error:

My Copy Data Source is as follows:

And my Connection is as follows:

I can't see any thing wrong with this setup. However, I keep on getting the error that the Value cannot be NULL. However, if I were hardcode the connection as follows, it would be successful

Can someone let me know where I'm going wrong?

Answer 1

Error code InvalidParameter Failure type User configuration issue Details ErrorCode=InvalidParameter, Type=Microsoft.Data Transfer.Common.Shared.Hybrid DeliveryException, Message=The value of the property 'tableName' is invalid: 'Value cannot be null. Parameter name: tableName'.,Source=,"Type=System.ArgumentNullException, Message=Value cannot be null. Parameter name: tableName,Source=Microsoft.Data Transfer.DataContracts,'

• As Joel Cochron suggested in comment section, the error message is because of the parameter created and parameter used in datasets are having different cases.
• Keep the parameter name in both places same, so that this error will not occur while debugging the pipeline.
• In this case, Change the parameter name from TableName to tableName in source settings.