You should be able to define input parameter type

[RedBraces]

The task wants all parameters to be of type string. This means that there is no way to execute a query such as "SELECT TOP(@rowCountParameter) * FROM MyTable" currently, forcing cumbersome checks in the Frends process.

It would be nice if the user could define the type of the SQL parameter in the task, or if the task could automatically recognize it.

[OssiGalkin]

That is a good proposition. Unfortunately, it is not possible to update existing task to have different parameter types. Doing so would change task fingerprint what would case task updating process in FRENDS to clear parameters. And when process is edited those parameters must be re-entered manually.

However, at some point, when support for FRENDS Linux completes, all tasks must be modified to target .Net standard 2.0. This is a good point to consider other changes as well, and this one is definitely one of them.