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.
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.
