Forum Discussion

joaosantos489_'s avatar
joaosantos489_
Copper Contributor
Apr 02, 2024

SSIS Odata source problem - No object exists with the ID 11.

Hey guys, I am currently facing a problem on my SSIS package and all your help would be very helpfull.

Here is the scenario,I have a data flow with a Odata Source inside, here is the image bellow.

 

I can confirm that the connection is working and the filter options are also working because I can view the data:
Unfortunately when I run the package I get the following error:

[SSIS.Pipeline] Erro: No object exists with the ID 11.
[Fonte de Dados OData 1 [2]] Erro: The Fonte de Dados OData 1 was unable to process the data. Excepção de HRESULT: 0xC0047072
[SSIS.Pipeline] Erro: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Fonte de Dados OData 1 returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

There is nothing else on the data flow, I just cant understand what is going on.
Appreciate all the help.

 

2 Replies

    • joaosantos489_'s avatar
      joaosantos489_
      Copper Contributor

      AndreasScheibli 

      As stupid as it sounds, you just need to unselect/select all the columns from the tab 'columns' inside the odata advanced editor. It worked for me.

Resources