Using EXEC in front gives the same result.
EXEC [HUB_StagingIn].[dbo].[stp_DLV_GetDeliveryInfo] 'STIB_TOLEDGER_LBB_MS', 623175
lso single or dubble quotes around '623175' make no difference:
EXEC [HUB_StagingIn].[dbo].[stp_DLV_GetDeliveryInfo] 'STIB_TOLEDGER_LBB_MS', '623175'
Usually that means that the DB credentials used by PowerCenter are not identical to those which you have used when logging on to the DB using DB Visualizer.
Can you please check the DB credentials in the relational connection used by the SQL Transformation?
Also, is there any DB log (produced by the SP) which might give you any hints why only NULL values are returned?
Credentials are ok. In the DBlog of SQL server we see that the SP has run and the result is 1 record.
I'm sorry, I'm out of ideas by now...