You'll need to attack this from the Windows security side of things. Make sure you're an administrator on the computer itself, then try it again.

I've never had much luck with those files either. Not sure what to tell you. While theoretically the checkdb process could have affected it, in terms of making the server...

Man, I swear I've seen that before, but thankfully it's been a while so I can't remember! I would try the Event Viewer and see if there's anything in there....

Is it feasible from a performance standpoint to build a view that concatenates the columns together, then join the Fact table to the view? I can't think of a way...

Can you create a new DB by right-clicking on the Databases heading in SSMS and choosing New Database...?

Are all users getting this, or just the one?

It looks like something is weird with the tabbing. When I removed the indentation from the offending line (in the SQL 2005 script) it worked fine.

georgew-918505 (1/22/2010)

---

Thanks for the informative intro. It couldn't have come at a better time for me, as I'm evaluating BI analysis and reporting tools. I've looked at QlikView, Tableau, Tibco...

Yes, it's serial because this section of our ETL can only be run serially. So I'd like it to take up more processors, if possible.

Well, this is the 64bit DTExec (as opposed to the DTExec that's in the Program Files (x86) folder).

As for the rest of what you're saying I'm not sure how to...

Boy, I don't know where it stores them. Seems like it must actually be storing them in the file system somewhere. How about running profiler and deploying a package to...

Hey Steve, you should get your son a Zune Pass for a couple of months and see what he thinks. Basically it's all-you-can-eat music for as long as you're subscribed....

Boy, there are definitely multiple schools of thought on this one. I've seen a lot of systems out there that combine simple code/description pairs like that into a single table...

Where are you located?

OK, figured it out.

I wrote a blog post about how to deal with it, and rather than reproduce it here:

http://dwexperience.blogspot.com/2009/06/troubleshooting-researching-or-tracking.html

HTH,