Basically I want to read messages from MSMQ public queue and push them to a SQL Server table.
Ideally I imagine an SSIS package (that a SQL Server Agent Job can execute every couple of hours) that read the messages and populate a SQL Server table.
I came across SSIS package "Message Queue Task" > Receive but don't know how to read such object and then push it further to a SQL Server table.
I tried Microsoft SQL Server receive function given in documentation but didn't understand.