You learn something new every day. Thank you that would explain it.

sorry got picked up by another problem and work part-time so just picking up the comments.

So thank you all who responded.

No, there was no backup - the DBAs were not...

thank you for input Smendle.

I have found the issue - now all I need is time....it's a complicated suite of packages designed by a third party

The reason for the failures...

OK, we differ in naming things. I double checked and BIDS is installed. It is what I use for managing and creating SSIS packages. When I create a package to...

Thank you Smendle for your input. I am not sure that I have not got BIDS installed already since I can create SSIS jobs but am going to verify this...

Thank you for quick response.

Regarding BIDS Session, no we set up DTS and its editor on the 2008 instance. I was not aware that there was any method other than...

That's a lot more useful than the links I found before. Thank you! 🙂

Thank you for that. You have saved me from insanity. I have checked my other databases and they all run in mode 90. Which would explain why I am having...

We have made no changes to any of the databases that I run the queries against. Compatibility Level is 80.

:-)That is an incredibly useful bit of code.

Thank You