IN and OUT parameters in tJDBCSP connecting to MS SQL Server
I need to invoke a MS SQL Server SP that runs in the SQL Server Studio like so: EXEC . @startDate = N'11/08/2012' Am able to see results when I run the SP in MS SQL Server Studio 2008. I followed the steps shown in this post http://www.talendforge.org/forum/viewtopic.php?pid=30420#p30420 but am getting a null pointer on the result set. UPDATE: I changed the SP component to tMSSqlSP and now am able to see a result set, but now I am getting a date parse error in tParseRecordSet_1.
Re: IN and OUT parameters in tJDBCSP connecting to MS SQL Server
The record set schema must fit to the fields (by name!) which your query or procedure provides as output. It sound like you are trying to read a date from a none date column - typically an problem in addressing the correct field.