Hi folks,
I am struggling with an SSIS (SQL Server Integration Services) related problem for over two days now, so I decided the ask you. ;-)
Following Setup is given
- WebServer / Application Server
- Database Server with SSIS
The Database Server is also hosting a webservice that does calls local SSIS Package. When calling the webservice directly on the db server, the SSIS Packet is executed as it should be. The Problem is now that calls to the webservice from the application server aren't working. But the most strange part comes now:
DEBUG 2009-09-08 15:30:43,044 Service WebService- Loading Package '\\MyPackage'
INFO 2009-09-08 15:30:43,244 Service WebService- Executing Package with Var1='102' and Filename='C:\\MyPackageExport.txt'
INFO 2009-09-08 15:30:43,244 Service WebService- Executing Package '\\MyPackage'
INFO 2009-09-08 15:30:53,163 WebService checkDtsResult - DTS Execution Result was 'SUCCESS'
The application server throws a timeout exception and exactly after this exception is thrown the package gets executed with "SUCCESS" as DTSExecutionResult.
I set the logging to max for this specific SSIS packet and nailed the delay down to the
PreExecute
Event.
Has anyone a clue, what happend here?
best regards,
Gordon