Well, it's been a few months since I posted this - we've gone live with this, and in the end, I had so many changes in the requirements it was scary...
no problem - each little bit or piece might be the one that helps reduce my problems. Staging database is already in simple mode, and is a seperate...
Do you have any other configuration tuning that you did on buffers for the data flows? I've been playing with DefaultbufferMaxRows, and...
I'll try and sanitize a image in the documentation, and upload it - but at the moment, deadlines and managers are shouting :) Yeah - I'm very...
Hi Martins (en hoe gaan dit?)... We are staging the data - I jsut didn't describe that above because it was getting so long a post. The inital...
The challenge: I have to extract and convert data between 2 SQL server systems - only 4 tables on the source systems, 8 tables on the target system....
Kurt, I am in the same boat. Environment: SQL 2005 SP2a CU2 Ent Ed 64-bit on Dell 6850, 4x dual core, 16 GB ram, active/passive cluster. 6 App...
the intermediate box was SP 2'd. However, it would appear that there were deployment issues with Sp2 to 2 of the clusters, and one of those is the...
I'll need to check - didn't do the install (was done by clients Senior DBA). I imagine it would have been done, though - the environment is set up...
Have a funny one that I've not yet resolved, and was wondering if I am the only one. SQL2005 SP1 server, Ent Ed, 64 bit, clustered machine. SP2a...
Hi Ken,<br /><br />I'll try and work through this soon-ish (next day or 2) - things are pretty hectic at the moment at work (only positive is I can...
What I've managed to do so far is to add a new transformation, and in ActiveX do the following:...
This may be a simple question, but I've had the good fortune (?) until now of not having ad to do anything with DTS. Unfortunately, that has changed,...
Furious, Uncontrollable Neurosis Panic, Chaos, Disorder ... my work here is done --unknown
Hi Joe, thanks for that - didn't think to turn on kernel time when I checked the task manager yesterday :-( It *appears* that the issue has been...
Hi all. We have an interesting situation we are trying to understand. Running SQL 2005 64 bit SP 1 hotfix rollup (9.0.2153) on SQL 2003 SP 2. We...
Here's a wild thought... how much control of the DB design etc. do you have? what about partitioning the table/db? Panic, Chaos, Disorder ... my...
Comments, improvement Welcome. Criticism accepted(... after all the practice I've had, I have to [<img src='/community/emoticons/emotion-1.gif'...
well, yes and no. I've been trying to find a way of doing this without doing a explicit loop (i.e. the while or a cursor). I have found a way to do...
Hi all, I'm trying to find a way to chagen a binary value into a char string with the SAME binary values, in a performant manner. In SQL 2000, it...
Separate names with a comma.
