How to pass a variable in an SQL query

[balupad14 (Balamurugan)]

Hi @eccprog

Here is the sample to pass the parameter to the query.

Insert SQL with variable / parameter giving error in ExecuteNonQuery activity

Hi @ramawat, I made a test what @Pablo_Sanchez mentioned with a little table. It is working fine. can you attache the table script and your insert query as a zip file. May be it helps to do the analysis. But any way, Here I have attached xaml and table for your reference. SqlServer.zip (2.7 KB) Regards Balamurugan.S

Regards
Balamurugan.S