About Execute Stored Procedure Task Type

The stored procedure task will look in the database for any stored procedure starting with ts_

Supports the following parameter types:

• String types: char, nchar, varchar, nvarchar
• Numeric types: int, smallint, tinyint, bigint, float, double, numeric, decimal
• True/False types: bit, boolean
• Date types: date, time, datetime

The stored procedures does not return any output. no return variables, or record sets.