SSIS Package runs on VS but not with SQL Server Agent after deployment

• Khattab19

  SSC Enthusiast

  Points: 112

  More actions

  November 17, 2022 at 12:25 pm

  #4114287

  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!

• Phil Parkin

  SSC Guru

  Points: 246988

  More actions

  November 17, 2022 at 1:33 pm

  #4114316

  Have you isolated the line of code which gives the error?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel