After upgrading my test server from SQL7 SP3 to SQL2k SP2, all our DTS tasks fail that perform OLAP tasks. When running these DTS tasks manually, I get "object variable or with block variable not set". Also, when viewing the OLAP processing task properties for any of these tasks, I find a button called "Cube Settings" in the #2 Select a processing option box. This does not appear under SQL7 SP3. If I press it, I get the error message above. If I move off the "#1 Object to process" selection, and then back, it disappears. If I do this for each OLAP task, and then save the DTS package, the DTS package seems to work fine.
Is there any way to correct this behavior without having to manually open/edit/save all our DTS tasks?