Hi Guys,
We have String variable Var_SetPipelineID and we have for each loop; Assigned inside we have set variable as below
Var_SetPipelineID =@item().Name
We have added on success Lookup Activity in Settings Query as below
SELECT [PipelineID]
FROM [dbo].[Pipeline]
Where [PipelineID]=@{variables('Var_SetPipelineID')}
got below error:
Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Invalid column name '1'.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Invalid column name '1'.,Source=.Net SqlClient Data Provider,SqlErrorNumber=207,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=207,State=1,Message=Invalid column name '1'.,},],'
1 is actual value in the variable.