Learn about SQL Server data type compatibility and implicit and explicit conversion. When you convert between an application variable and a [!INCLUDE ssNoVersion] result set column, return code, ...

Data conversion transformation or derived column transformation? It depends and you've also got other options.