I'm using SqlServer 2008/SSIS/Excel 2007. My desktop is Windows server standard 2007. My SQLServer is on a different server. I can create a SSIS package that writes to Excel and it doesn't demand unicode. But when I copy the package to the server where SQLServer is(temporary necessary) it gives error you must use unicode when exporting to Excel. I can fix it easy enough by converting to unicode on the selects, but there must be some setting on one machine and not the other. Has anyone here used IDTSConnectionManagerFlatFile100.Unicode Property, maybe this could help.

I would check around for Language and Character Set values in the Registry or Client setting. We use Oracle and there is an NLS_LANG setting in the Registry that is vital to proper execution of SSIS packages. Good luck.Brian