Heh... just one of the many reasons why...

Apologies... I posted a reply on the wrong thread and removed it.

Thanks Jeff.  This appears to be exactly what I am looking for.  How would I replace the string with a field name called int_ID now?  I don't know what...

You're correct in saying that loading a table with a Clustered Index in place does mean that you have to only use a single thread to be able to take...

Some of the details may be irrelevant to parallel processing but, in my mind anyway, parallel processing during the initial load is just one part of the equation.  As you...

@iposner ,

I'm curious...  Did all 10,000 files have precisely the same format?  And what was that format?  CSV?  TSV?  Fixed Width Fields?  And can you make a guess as to...

In my previous post I wasn't making any point at all about portability, which I agree is no necessary consideration in designing a database. My point was just about...

1. Why a unique non-clustered index ? why not just a non-clustered index for [NI_APPLIED_LOCK_SBL3R8]. Because I don't know the nature of the data if those columns has repeated...

Business data belongs to nominated data controllers and data subjects. Data does not belong to database designers and developers and as a technology professional myself I try to keep...

Rather than having a master package distribute the list of files to process, another approach is to give each package the rules it needs to process the subset of...

Just my take on this... single and fairly short formula that does the replacements only once.  This, of course, assumes that you'll always be working values where you want to...

I am working in SSIS (Sql server version 2012) , I have a requirement to add two new columns to a destination table which already has five years of...

I think that three things need to be done before anything else....

1. Add an index to support the lookup for the update.  It should be a unique index consisting of...

A part of the reason why I use IDENTITY instead of sequence is because IDENTITY IS much more difficult to update and it's flat out not supposed to ever be...

before loading csv to SQL is there a way to validate against table schema to catch potential data issues and row number

create a good file(records pass) and bad file(for...