I have an Execute SQL task in SSIS which just fires a stored procedure. Connection type is OLEDB.
The stored procedure has worked as expected for months, but last week the SSIS package has hanged twice when executing it.
Works fine from SSMS, works fine after drop-create with no changes... ??