CODEWITHSUNDEEP
ssis
RRIVAS
RRIVAS

Reputation:

Calling a Stored Procedure From SSIS

Im trying to call the procedure with this form.

EXEC dbo.sp_consulta param

In parameters mapping i have this variable: "param".

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:

error converting data type nvarchar to int

Upvotes: 1

Views: 5890

Answers (1)

James McShane
James McShane

Reputation: 126

If you are executing this from a SQL task the correct format would be EXEC dbo.sp_consulta ?

See: http://msdn.microsoft.com/en-us/library/cc280502.aspx

Upvotes: 1

Related Questions