executing SSIS package(import data from Excel to sqlserver) in C# creates excel proess in task manager .

Question

Hi,

I develop a c#program that execute SSIS package on button click and it import data from excel to sqlserver. It works fine first time and when i tried to run again. It shows error that excel fil is already open.

To run the program again I made "endtask" the "excel processes" in "Task manager" .

How can this problem be solved? .

with regards.

Answer 1

Yes. you should add to your code ReleaseObject procedure because close file is not enough.
In VB I use code looks like:

Private Sub ReleaseObject(ByVal obj As Object)  
    Try  
        System.Runtime.InteropServices.Marshal.FinalReleaseComObject(obj)  
        obj = Nothing  
    Catch ex As Exception  
        obj = Nothing  
    Finally  
        GC.Collect()  
        GC.WaitForPendingFinalizers()  
    End Try  
End Sub  

and you can use it:

ReleaseObject(wks)  
wkb.Close(False) ' or True if you save it once with name'  
ReleaseObject(wkb)  

Regards

Answer 2

You have tagged this office-addins-dev, but if I understand correctly, you are not making an Office Add-in. Is that correct?