September 22, 2015 at 4:28 pm
Anybody here experienced difficulty in passing a date parameter in a stored procedure through OLEDB Source (Data flow task). We have a multipurpose stored proc in which one of the many expected parameter is a date. It keeps giving me the following error:Description: "Operand type clash: int is incompatible with date"- although there is no integer.
One way to fix it would be change the data type from date to datetime in proc but I can't do that since it is multi-purpose proc. I didn't find anything good on the net.
EXEC dbo.spDoSomething ?
Any suggestions?
September 22, 2015 at 7:35 pm
peacesells (9/22/2015)
Anybody here experienced difficulty in passing a date parameter in a stored procedure through OLEDB Source (Data flow task). We have a multipurpose stored proc in which one of the many expected parameter is a date. It keeps giving me the following error:Description: "Operand type clash: int is incompatible with date"- although there is no integer.One way to fix it would be change the data type from date to datetime in proc but I can't do that since it is multi-purpose proc. I didn't find anything good on the net.
EXEC dbo.spDoSomething ?
Any suggestions?
Have a look at this article on MSDN: Parameters and Return Codes in the Execute SQL Task
😎
September 29, 2015 at 3:32 pm
This is for Execute Sql Task. Its completely different in OLEDB Source in Data flow task. My issue was in OLEDB Source in DFT.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply