I have a connection into SQL via OLE DB and have a daily task scheduled to automatically pull through the days data, however, the data isn't pulling through.
If I open Data Manager, click on the table and Select Data from Source, Update and then the data pulls through as expected. I have checked the QMC and the app runs fine so I am confused as to why the data won't pull through automatically.
