IN and OUT parameters in tJDBCSP connecting to MS SQL Server

One Star

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

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.