Function call from SSIS has no effect

More
9 years 4 months ago #6677 by 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?

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #6679 by 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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.047 seconds
Powered by Kunena Forum