Got a bit of an unusual one that's got me scratching my head.
I'm covering a colleague while they are on holiday and as per the law of sod, his BI system decides to go wrong on the first day.
After picking my way through it all, I discovered the issue lies with a database that is restored onto a different server daily is failing to copy the data in one table (again sods law it just happens to be the most important table).
There are no errors on all his procedures and tasks so this has proved hard to find.
I've ran the whole process manually and still doesn't bring the data through.
Checked all the standard things, even restored the backup to a different server.
Has anyone else ever had this happen.
Thanks in advance.
Chris
Did you check to make sure that the table in the source database has data?