Bumping the post because I have received no answers for the last question. I've switched back to trying to use the .dll in a Script Task (rather than a Script...

Actually I had just created the Script Task on the Control Flow. Do you think a Data Flow task would be better for this?

I'm a little worried about...

Oy! I get all the fun projects. I love a challenge. I don't love being on a deadline to learn a new programming language, though.

Any advice on decrypting...

I think it would be nice to archive off the older SQL version forums so the threads are still available even if the posting ability is not.

I...

Hola, Fellow Threadzians.

As I push my head above dense project waters to grab a breath of fresh air, I was wondering if anyone would care to assist me...

I probably shouldn't have used the word "upgraded." I did get a new box entirely, fresh install of the OS.

Sorry for the length of time to respond to...

The worst part about it is the people who were developing this code kept insisting on turning SQL tables into flat files and doing stupid stuff like that, no matter...

Thanks, Drew. I was working on that, but changing different items in the CASE. I'll take a look at that and see how it works.

BAH. I thought I was through with this, but I just found an outlier.

When testing with the this data:

INSERT INTO #MyTemp (Office, POID, DeliverySite,...

Drew, thank you so very much. I'd never heard of LAG() or the ROWS UNBOUNDED PRECEDING stuff until now. I love this job because I learn new things every day.