When Azure SQL is used, the "Get Transaction Item" activity fails to retrieve items from the Queue. However, the "Get Queue Item" works as expected. What is the reason and resolution?
Root Cause:
Azure SQL Auto index is enabled.
Resolution:
Azure SQL Auto index needs to be turned off.
Visit Automatic Tuning Overview to learn how to turn CREATE INDEX off.