Right again.

What started out to be a very frustating day is turning into a bright weekend.

I didn't realize there was so much to SQL. Did you take a class or...

I'm getting an error with one of the fields that that I am bringing over from the stage table to the destination table.

the stage table has a data type of varchar...

I tried to do it as an activeX script as part of the transformation but I couldn't get it to work.

I did get it to work with a staging table,...

Thanks for your suggestion. I think that would work but I have a system that is going to create a new .txt file with 00/00/0000 dates every night. I'm trying...