Insert data in queue with Bulk add Queue items error

[Anil_G (Anil Gorthi)]

@Deep_HML

To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those…

And yes the limit is 15k or so…

We can break the table into rows of 10k and add in 3 loops

So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer

And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable

And use the chunkdt to load the queue

Hope this helps

Cheers