Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.
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):
Any suggestions where the problem may come from?
- Posts: 2
- Joined: Mon Sep 03, 2012 3:02 am
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.
- Site Admin
- Posts: 347
- Joined: Wed Oct 29, 2008 11:27 pm
Return to SQL Server/DTS/SSIS/Linked servers/Replication
Who is online
Users browsing this forum: Yahoo [Bot] and 0 guests