I have a stored procedure something like this exec sp_name startdate, enddate. I have to run this in an ssis package.
The startdate and enddate values are loaded from a sql query, so i have declared variables (startdate,enddate) and got those values from the query using evaluateasexpression. Now, when i call the stored procedure in execute sql task it fails as the datatype
from the variable is string and the stored procedure parameter (startdate,enddate) are datetime. Please help me.
The following are my settings in execute sql task editor
SQL statement : EXEC sp_name ?,?
data Type: Date
Parameter name : 0
Parameter size : -1
View Complete Post