Check the Visible property of the cube. I have noticed that sometimes, for reasons I haven't been able to determine, this gets 'flipped' to false and will generate the error...

I should have added that the cause of the intermittent nature of the problem must have been related to variances in data and perhaps quantities. In either event, disabling parallelism...

Steve et al,

I was able to make the query work quite nicely by setting the Option MAXDOP(1) in the query. Tom Moreau's suggestions at http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.server&mid=2f59d0ed-086f-4bd2-8117-b05882d7f1d4

(watch for the wrap there, that...

Thanks Steve, Phill, and rstone for the suggestions and input. I fixed the issue by removing the /PAE and /3GB switches from the boot.ini file and disabling AWE in sql...

Are the records that are short by one field missing a carriage return/line feed character at the end? If so, you could loop through the file first and insert the...

I do this in SQL 2000...then simply do a delete query on my table right after the records are imported, removing those records where the end columns are null.

Michael Weiss

I would put my code in a stored procedure with the variable defined as an output variable. Then you can assign the value of the output variable to the global...

Thank you, Phill...you DTS wizard you! Using oTask.Properties("SQLStatement").Value did the trick! Can't thank you enough...

Michael

Michael Weiss

I am able to set up a test user on server1 - the win2k server box. I can log into sql server on this machine using sql authentication and access...

Thank you, Antares. I have tried your suggestion and still cannot get the authentication to work properly. Here is what I have configured and tested (to no avail) so far:

One...

Peter,

If you are not running SQL Server in a production environment, you can use the Developer Edition which contains the same functionality as the Enterprise Edition. The cost for the...

Sorry, Peter. I was hoping it would be a simple solution for you. I would try installing sp3 for both sql server and for analysis services. Note: these are two...

Open the cube editor in Analysis Services and check the 'Visible' property to make sure it is set to 'true'. Sometimes this property value gets flipped to false for reasons...

Gary,

Just curious...what are your reasons for not using DTS against a production box? Or are you only referring to using the DTS Transfer Database function?

Thanks,

Michael Weiss

Thanks, Steve...in your experience, if I decide to keep it all in one table and use views off that table for the individual dimensions, do you see any potential pitfalls...