Female DBA (sure they exist and in response to your 'Gentlemen')

Invisible/Non-existant DBA

Totally agree GSquared,

as I say the table we're inserting into in this case is effectively a temp table within a datamart process and the join is pretty much a...

Thank you all for your replies. With this information we've managed quite a simple work around by first loading the data into a new varchar column and then sorting...

I have used a table to hold the loop counter. Running the whole statement was too much for the memory available so it was broken down into processing by...

Suffolk

England

(UK)

Dizzy Desi (10/5/2010)

---

While I agree that women and men are different in many ways, I think they both possess the same abilities to learn and perform.

However, I have to mention...

It's a bit harsh to say that if you're not supported at home then it's your own fault, however it's true that people of either gender have home issues that...

Ah,

sorry, don't think what I said was what I actually meant there. The idea was that if you have a login to Oracle which can read the data that is...

That makes sense, however I would have thought the access rights for this would not be different to those required for openquery - in both cases your looking for a...

It's never easy is it - or you wouldn't have posted I guess. How does step 1 work currently if SQL can't access Oracle, I must have misunderstood.

Briefly,

1. Set up a linked server connection for each Oracle database.

2. In the DTS transformation

set the source connection to the...

You state that 'using DTS for Oracle-Oracle transactions is slow' but I've not necessarily found this to be true, especially if the oracle databases are on separate servers.

It's worth...

Also beware that auto-shrink can cause locking issues. When we build our datawarehouses if auto shrink is on it can try to shrink the file while it's still writing and...

The SQL Server does actaully have a name - it just doesn't show in EM. If you open Query Analyser from EM it will be shown at the top of the...

Within disconnected edit you will see tasks and steps.  Each step runs a task.  The steps may be running the old named tasks rather than the new.  You can also...