title: Calling a Stored Procedure From SSIS
body: <p>Im trying to call the procedure with this form.</p>
  
  <p>EXEC dbo.sp_consulta param</p>
  
  <p>In parameters mapping i have this variable: "param".</p>
  
  <p>In the variable that is holding the parameter im assigning int16 as the type but for the parameter type there is no int16, so I'm using short or signed. The error I'm getting is this:</p>
  
  <p>error converting data type nvarchar to int</p>