I kind of figured it's in this area but would like to see a specific place on both servers to see a difference so I know once changed I have...

Thank you so much for your reply.  I did the chcp and both systems show IBM437 OEM United States. 

Here's what I am doing.  I have an ssis...

I've never used event handlers until this and I can't seem to get them to work. I tried to write the variables to a SQL table but the table was...

I'm on SQLServer 2008, sorry I forgot to mention that.

I appreciate ALL the replies. I've learned something from each.

Your solutions provided what I needed...

Just curious. There's always more than one way to do things and you can learn from each approach.

are there any other ways of accomplishing this?