Solution, Round 1:

if OBJECT_ID('tempdb..#Employee') is not null

drop table #Employee

go

create table #Employee

(EmployeeID int,

Work0110 bit,

...

Hey Paul, welcome to the club.

Your brother Frank does nice work....

Be gentle...

cvandevoorde (12/6/2010)

---

Huh... The 2 columns I noticed the problem with, the PREFIX and SUFFIX, are char(8). The others are varchar.

I still don't understand why, if the columns...

Well, this amused me... I recieved this PM. Allow me to share my reply with you:

petersonlawson9 (12/6/2010)

---

READ AND GET BACK TO ME

Dear Friend

i am Mr.peterson lawson, personal friend...

I did a stint at GoDaddy. While I'm not excited by the leadership there (and that's all I'll say publically), most of the tech side of the house actually...

ken.trock (12/6/2010)

---

Lowell (12/6/2010)

---

i think you'll just have to wrap a section of the query into a subquery, since the data has to be filtered on the LIKE statement first;

because the...

You've run into a common issue, and it's a natural one to make. The Where clause limits the data, then we do the rest...

Sadly, this isn't true. You...

I need to agree here, SSIS for this is using a sledgehammer as a screwdriver.

Activeworkbook.worksheets(1).move ("Targetfile", vbLastSheet) is the syntax you want, if memory serves. It's been about 10...

I think this is one of those things in the back of my head I always knew, and just never really appreciated just how intrusive the problem could be.

Awesome article,...

Short form: No, not directly. Carries too much metadata.

Longer form: Screen print is your best, optimal choice here. Mostly because it's your only one.

I know there's all the rendering bits and whatnot to make sites pretty, but I know what 2400 baud looks like. I tried playing graphical MUSH's on them. ...

Trey Staker (12/3/2010)

---

There should be a spackle article on this... I thought it was just you so I went in and set up a package and ran into the...

For those playing along at home, Ragged Right needs a specific setup, you need to have one extra column in the advanced section for the CR/LF. Basically, it creates...

markshelden (12/3/2010)

---

More lousy SSIS stuff. Amazing how they've screwed up some of the simplest items.

Anyway, I found the answer in another thread. You need to use the ragged...