I'm working on a quick and dirty solution that, having only been given the problem yesterday, it needs to be tested and up in production tomorrow.
I'm running a DTS package from within a cursor in a stored procedure. The first time I enter into the cursor the DTS package looks like it executes then goes back into the stored procedure and fetches the next value for the cursor. The second time through the cursor, the process seems to hang when the DTS package is executed.
Can anyone please enlighten me of the cause for this or what things I should be checking to fix it.
I'm running a DTS package from within a cursor in a stored procedure. The first time I enter into the cursor the DTS package looks like it executes then goes back into the stored procedure and fetches the next value for the cursor. The second time through the cursor, the process seems to hang when the DTS package is executed.
Can anyone please enlighten me of the cause for this or what things I should be checking to fix it.