MrDavidThorn
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.