Like I said before, I didn't write that stored procedure! Whomever had this job before me was cursor happy:w00t:

That makes sense to me too. I think the post right before yours describes what actually happened. Since there was a cursor in the stored procedure that had...

No, the stored procedure is executed once, however it contains a cursor (I didn't write it) and it does not contain error handling. So every time it ran it...

Thank you for your reply. I will explore that option!

So it happened again. It was on a task that calls a stored procedure, passing in one variable. Like I said the MaximumErrorCount is 1 and FailPackageOnFailure is...

thank you all for your help. I will see what my manager says before I delete anything.

I have checked all the databases and run this query but the file is not in the result set:

SELECT name, physical_name AS current_file_location

FROM sys.master_files order by name

If I run it long enough it finishes.

try looking at the regular expressions. Here is just one article on this: http://msdn.microsoft.com/en-us/magazine/cc163473.aspx

I am calling the stored procedure from an Execute SQL task.

Yes, I am calling the stored procedure from BIDS / SSIS 2008.

I understand -- If you add the event handler to just the package failure tab and set all your tasks to FailParentOnFailure = false and FailPackageonFailure = true then when...

Well, I answered one of my questions! I dropped the indexes and the data flow is still running, but much, much faster! I am still open to more...

In my packages I have one stored procedure to handle all events I want to log. In the Event Handlers tab, I create an Execute SQL task to call...

That issue has been resolved but I do have another that hangs where it is calling a stored procedure that uses a cursor -- somebody else wrote the code and...