• We have a similar issue. Daily we replace a spreadsheet with a template spreadsheet and write out the new data set. All that works fine. The problem is that three of the columns should be numeric but excel keeps changing to text. The first time the package was created the initial "table" had the correct datatype. We are selecting integers and outputting integers. But in subsequent runs of the package the datatype is changed to text. This is a real problem. Daily someone has to edit the spreadsheet and convert the text to numeric -- which defeats the purpose of a scheduled job.

    Does anyone know how to force the output into excel to retain the datatype? I have already saved the package as a VBS script and modified the output datatype. It appears to be an Excel issue. Thank you much for any help you can give.