<div>
Hi Roy, I created the macro and it runs in the open event of the workbook. However, the file gets saved with a .xlsm extension which works fine outside of SSIS but my package is uses a data flow task to write to the Excel file from a SQL Server database. &nbsp;Any suggestions as to how to get around this problem. &nbsp;Thanks.
</div>


Hi Roy, I created the macro and it runs in the open event of the workbook. However, the file gets saved with a .xlsm extension which works fine outside of SSIS but my package is uses a data flow task to write to the Excel file from a SQL Server database.  Any suggestions as to how to get around this problem.  Thanks.

<div>
If SSIS doesn't recognise &nbsp;the xlsm format then you could put the code into an addin and manually run the code when required.
</div>


If SSIS doesn't recognise  the xlsm format then you could put the code into an addin and manually run the code when required.

<div>
The suggestion to run a simple macro to convert the cells back to Text is what I needed. However, I cannot run this manually as it is part of a scheduled SSIS package and SSIS does not recognize an .xslm file. I'm going to try to use a script task within SSIS using c# to see if that will work.
</div>


The suggestion to run a simple macro to convert the cells back to Text is what I needed. However, I cannot run this manually as it is part of a scheduled SSIS package and SSIS does not recognize an .xslm file. I'm going to try to use a script task within SSIS using c# to see if that will work.

<div>
<div class="content wysiwyg-content">
I have an SSIS package (2008 R2) where I have a SQL Server source writing to an Excel file. The Excel file is a template and all of the columns are TEXT. After the data is written to the Excel file the cells that now contain data have changed from TEXT to GENERAL. How do I prevent this so that all cells remain TEXT.
</div>
</div>


I have an SSIS package (2008 R2) where I have a SQL Server source writing to an Excel file. The Excel file is a template and all of the columns are TEXT. After the data is written to the Excel file the cells that now contain data have changed from TEXT to GENERAL. How do I prevent this so that all cells remain TEXT.

How do I get stop Excel columns from changing from TEXT to GENERAL when my data task within SSIS writes from an OLEDB to my Excel template file?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.