I think I need to clarify a couple things....

I could have easily turned the query into a table valued function that I could just call; however, that...

Lynn,

Saw this while I was doing dishes... LOL It's mothers day...

Anyway, thanks for the reply. There is a very specific reason that fields are data type varchar(255). Actually,...

I can't configure it in a query hint since it's not in a query. I'm using a Data Flow Task in BIDS to import from a Flat File (Flat...

@Brain... Do you have a friend named Pinky?

Ok, so I figured I'd use an Execute SQL Task to set the param to 1; however, is this going to affect the...

Can you go into more detail about MAXDOP? I don't believe I've seen that, or noticed it, in BIDS containers.

bump...

Bueller?

Unfortunately, I don't know how to write Visual anything these days... script task looks like a wash.

I could write a SQL Script to do it, then the only...

Sorry dude... but I have no idea how to use that in a DTSX package... I scanned through it, but I'm going to have to interpret and apply...

Good idea... I"ll pass that on to the .Net folks and see what I get.

That idea bombed for a complicated reason I don't feel like explaining... darn.... Essentially, the suffexed the file name with some code that makes no sense to...

Bueller? is a throwback to the OLD movie "Ferris Bueller's Day Off". He played hooky from school. His teacher was a young Ben Stein who famously called "Bueller?"...

Bueller?

Bump.....

3 tables left joined to the same field in the first table, all have indexes.

Each server is a VM with memory allocated via the Sys Admin. I can ask them to bump it up. There are 4 servers on this VM, total...