This is my update statement:

I have tried these 2 statements as underneath.

update dbo.BackupDeviceInfo

set filepath = "C:\ABCDEF\" +"?"

update dbo.BackupDeviceInfo

set filepath = "C:\ABCDEF\" +?

My parameter mapping under Execute SQL editor has these values under variable mapping :

user::currentserver as in the for each loop container.

I get the following error.

[Execute SQL Task] Error: Executing the query "update dbo.Table1

set filepath = "\\abc..." failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Please advise.