Thanks for the ideas, I will try both and see what user feedback prefers.

Further reading has led me to believe it may be possible to edit the CSS on the...

Hi,

Check the version of the DB2 oledb driver, it's probably an early version that is not *quite* compatible.

I remember having problems when 2005 was first released with DB2 SSIS extraction....

Thanks for the replies, makes perfect sense to do it like that.

😀

R.

Thanks all for the replies, I figured it out and could not have done it without you (especially your code example Terry!).

Much appreciated.

😀

Richard

It seems that if you have an incorrect path (or no path) specified in the destination for the rename, you can get one of the two errors posted.

ie file does...

smunson (1/5/2009)

---

Assumptions, assumptions... Why would you bother with a rename option if you were going to delete the file at the same time? It's a really...

Sorry I should have said the first ID field listed is a primary key of that table.

And you're right of course, the last table should be ProductAttributeValue and the two...

colin Leversuch-Roberts (9/17/2008)

---

I'm interested in where the figure of 80 came from? a hit ratio I can follow but a counter of reads would be hardware specific. I have a...

I have to say I've never come across a system where people are changing the actual structure of the database itself on a regular basis.

However, it's not a complete show-stopper....

GSquared is absolutely right: you need to create a normalised structure out of that mess. It's the only way to go. Preferably get someone who knows what they are doing...

Thank you both! 😀

Richard

My box has 8 CPU's, so that explains why sqlservr is at 200%!

Thank you Gail - yet another clear and concise explanation. Cheers! 🙂

Thanks for all the replies. I was aware that peer-to-peer replication is a kind-of scale-out solution, with the limitations that Gail mentions:

"You can use peer-to-peer replication for scale out. It...

You are correct, I've found it, so thank you for the help.

Matt, thanks for that. Those options are part of my ammunition toolbox now!