good morning to all.
I'm currently working with some SSIS packages that upload new data from an Excel file to a CosmosDB Collection.
In some Collections it works just fine but in some other identical Collections SSIS fails and gives me this error message:
"No Document ID specified. Please specify a ID when inserting data".
I normally pass the id field as a GUID and that's enough, but in some cases the collection rejects the row, as if I'm not passing the id for the new row. I've tried to pass it as a regular string and as a GUID field, but neither of both work as it should.
I have also compared if there is any difference between the collections that work fine with the ID field and the collections that reject the row, having seen no difference whatsoever.
I really don't know where else could I look to fix this problem.