I have an SSIS package that uses an SQL Task to run a Stored Procedure in an Oracle database. The connection to Oracle is made via the Native OLE DB\Microsoft OLE DB Provider for Oracle.
There are some issues with the data in the Oracle system and sometimes the processing hangs so I have set a TimeOut value on the SQL Task.However the timeout is never triggered, I have had it set to 1800 seconds and the SQL Task has just thought it is still running until I've manually stopped the SSIS package.
Is there a way to get a timeout back from Oracle within SSIS?