Deal with HEX values for CDC

castiellll — Wed, 10 Apr 2019 17:26:04 GMT

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.

Re: Deal with HEX values for CDC

castiellll — Wed, 10 Apr 2019 18:32:09 GMT

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