I'm the someone it surely helped today. Thanks! I had the concept right with the CASE but couldn't figure out exactly where it went with the OVER part.

~...

This is admittedly a niggling question, but in Jeff's sample cursor, he used:

DECLARE Employee_Cursor CURSOR LOCAL FORWARD_ONLY READ_ONLY

If you want the cursor to be FORWARD_ONLY READ_ONLY, why wouldn't you...

Wow! The client ended up going in a different direction for data conversion so I never needed to finish that awful package. However, it's a standard file format...

Excellent post. I'm a self-taught geek as well. I got a summer job at a software company when I was 19 and never looked back. (Besides, I...

The original poster never took your offer, but I'd like to. I haven't configured a BCP file using SSIS Bulk Insert before, but if it's going to process my...