I have two SQL servers, one is running SQLServer 7.0 (7.00.842) and the other is running SQLServer 2000 (8.00.760). I've linked the servers (on the SQL 7.0 box).
I need to copy some data from the 7.0 box to the 2000 box on a nightly basis. I wrote the query, and it works fine in QA when connected to the 7.0 box. Thinking everything was going ok, I built a DTS package with the same sql code on the same server.
Strangely, when I run the DTS package I receive an "Invalid Pointer" error. And of course, when I schedule the job to run, it also fails.
Any idea why this is happening? The only information on this "Invalid Pointer" error I can find refers to an older service pack, which is not the problem in this case.
Any pointers would be much appreciated. Thanks!