Post reply

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

  • 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!

  • 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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply