I am facing an issue where after the completion of an SSIS task where excel is involved the particular excel session/instance is still active and on again using that package where that particular template/excel is used it throws an error that it already in use. Work around is to manually kill that particular instance- but We need to handle that programatically. How can we overcome this programatically. Some of the solution which came to my mind is capture a Unique Identifier of that particular excel instance and kill that at the completion of the packge (may be using script task)- But I am not sure how to do that ? Please help me with above solution or another approcah will be appreciated.. Thanks in advancemadhur_ms

Do use any code to operate on Excel? Then you did not properly handled the interactions with the Excel file e.g. neglected to properly close it. If not then you may resort to using a script that incorporates the KILL.exe to remove the Excel.exe image from the memory forcefully. Typically you filter by process name with PULIST.exe to find the excel process ID to kill. All the EXEs are from the windows resource kit.Arthur My Blog

I'm assuming you're using the Excel COM API, and this is leaving zombie Excel processes running? You should know that using the Office COM API is not recommended or supported on server OSes. Let us know what you're attempting to accomplish with the API so we can suggest alternatives. Talk to me now on