Deal with HEX values for CDC

[castiellll]

Hello everybody,

I am using CDC technology in MSSql and use a stored procedure with some parameters to retrieve the data.

The start and end timestamps are returned by another SP and are in Hexadecimal.

I stored them in global variables as byte[].

I get the parameters from tFixedFlowInput and enter them as 'In' Param to the procedure.

But 'result' which is a result set is null. I tried manually the SP in SQL server and it returns results.

I don't know if I missed something or if the problem comes from the byte[] of the timestamps ??

Thank you in advance for  you help.

Sofiane.

[castiellll · Accepted solution]

Ok finally after profiling it, we saw that it was an error on the function name.