So you only need to do this once, or you need to automate it?

If you just need to do it once, how many files are there? Why not just...

Apparently this is a bug, according to this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1

It sounds like either you haven't installed SP1, you don't have SSIS installed and generated the code through the import/export...

I'll try the named sets a bit more. The initial one that I created acted like it only supplied a preset of filters, but maybe it's just what we...

Now that I've thought about this, and tinkered with it a bit, I definitely like it. I think what I like best about this solution as opposed to some...

Thanks for the great article Andy. It definitely clarifies some of the nagging feelings I've had about how I'm "supposed to logically want to manage" now that I've been...

cmcklw (2/11/2008)

---

Rick Todd (2/11/2008)

---

cmcklw:

I'm doing my compare based on the Business Key of the table, as opposed to something I'm generating internally (like the Surrogate Keys I'm generating with an...

cmcklw:

I'm doing my compare based on the Business Key of the table, as opposed to something I'm generating internally (like the Surrogate Keys I'm generating with an IDENTITY column). ...

I haven't used the Copy Schema or even the Transfer... tasks, but it sure looks like your error is caused by exactly what it's saying...a duplicate key entry. Is...

Well for starters I would say that you should have a surrogate key as your primary key, rather than what I'm guessing is the primary key from your production system...

Oh, I thought that "thanks for voting!" was sort of a "thanks in advance" kind of thing. I guess that's why I can't vote either

I stumbled on this article because I'm trying to figure out how to vote. So, how do I vote?

I'm definitely a believer in what Kimball has to say, and like to think I'm following his methodology. Although it would certainly appear I've gotten a little carried away...

So would that be something done on the T-SQL side, or the SSAS side? I've been hoping all this time that there would be a way to make SSAS...

I'll try that today Crispin, thanks. I figure it's not a unique problem, I was just hoping someone could guide me in the right direction. Hopefully you have.

We had a very similar issue at the place where I used to work. We would find that the SP in question would run slowly from the client, but...