Is there an algorithm out there similar to this that will dicern from people's first name what gender they are? This may be asking a bit much, but I...

No. And there are no nulls.

You know, it worked. It tool 3.58 minutes, but it worked. 🙂

I retired too, Jared. The table I'm working with is way too big for the cost in performance this is adding. I get into these mind-sets where I...

Luis, You make my query look like a school kid's art project. How do you think up that kind of thing? Thank you!

GSquared, Thank you for this solution. This in deed does do exactly what I was asking for, but maybe I'm making it too complicated? Now that I'm looking...

You hit the nail right on the head with that one....

I did figure out how to add a reference, but will still take easier methods for reading a zip file in SSIS.

First of all, I think I need to count my blessings that there are not a bunch of "guys" here who can write or alter anything on the server. ...

HA! This is funny. When the table was imported, instead of null values, the word "NULL" was actually inserted into the records.

When running isdate the only records with a '0' are NULL columns. I wouldn't think that's what's messing it up. Well, aparently that was the problem, since when I ran...

This was really fun to go through. I'm looking for other tutorials on C# to use in SSIS, but am only seeing videos. Anyone know of a good site to...

In the Transfer table, add a field 'existing' and default it to 0. Now, do an update on Transfer to update this field to 1 by joining to the...

I would sincerely look into 2-staging this process however. Holding insert/exclusive locks on the Alvis_22 schema table until this completes is just bad form. Do the long work...

WOW. Lowell and Craig -- you guys really went above and beyond in helping me with this mundane issue. Thank you so much.