Hello there!
I am trying to run a .dtsx package that fills excel sheets using c# and then format them before uploading them to sharepoint,
it runs into this error : The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there.
i tried disabling it to see if the formating task fares any better and the below error occurs:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).
any help would be much appreciated!