Function call from SSIS has no effect

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Function call from SSIS has no effect

Postby wmair » Wed Sep 05, 2012 2:17 am

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?
wmair
 
Posts: 2
Joined: Mon Sep 03, 2012 3:02 am

Re: Function call from SSIS has no effect

Postby Moderator » Sun Sep 09, 2012 9:16 pm

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.
User avatar
Moderator
Site Admin
 
Posts: 302
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests

cron