I have a DTS package ,which used ActiveX to call Excel application macro to update a few worksheets.
Each time it execute in the SQL Server Agent, it seem to go on forever. Usually takes around 5 to 7 mins. But, if I execute manually sometime it completed successfully and recently giving me a message like ‘Switch’ or ‘Retry’ because process busy.
How can I debug such and error?
