Does QA happen to be a 32-bit install (OS/SQL) vs. production being a 64-bit install?

Check the SSIS data type. It sounds like you've read that data in as a floating point (DT_R4 or DT_R8). You'll need to read it in as a...

Not typically, no. You're hosed. That's life when reading and writing to Excel.

The best "quick" fix I can offer may not be something you want to use, and...

The problem is that you're trying to replace the value in the "studentkey" column. That column is already defined as a DT_WSTR. Since it's an existing column that...

For those of you looking for more resources on this subject, I have two articles related that cover some of the same ground:

SSIS in 32- and 64-bits

Interacting with Office in...