We help IT Professionals succeed at work.

Passing INPUT Parameters to SSIS

Hi experts

Im trying to Pass a package variable to a SQL stored procedure - my SQL statement is
Exec dbo.spCreate_ProcessLogs @FromDate =?, @ToDate=? and the connection type is OLE DB -  My passed parameters are below in a screen shot, Im getting the error message

Exec dbo.spCreate_ProcessLogs @FromDate =?, @ToDate=?" failed with the following error: "Invalid character value for cast specification". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Obviously my syntax is wrong, any ideas
Task failed: Create Log Success
 SCREENSHOT
Comment
Watch Question

Commented:
Remove the parameter Names from the Parameter Name Space and ADD 0 and 1 instead

The parameters are mapped accordingly in the same order... So make sure they are used in the right order as parameter names

http://www.sqlis.com/post/The-Execute-SQL-Task.aspx