Function call from SSIS has no effect

[wmair]

My function call from SSIS through a execute-SQL module is completed successfull, however, nothing happens in the database. If i call the function from the database, it works like a charm.
The SQL statement i use is as follows (the function is used to delete the contents of two tables and is executed from root):

SELECT public.cleartables();

Any suggestions where the problem may come from?

[Moderator]

It is hard to tell. Could you run PGNP Profiler and see if any errors can be seen in the log? What version of the PGNP provider are you using?

If that does not help, please send us the stored proc definition.