SSIS Excel export changes # to

by aman6496   Last Updated December 07, 2017 11:06 AM

I am exporting an excel file through SSIS using excel connection manager. I am using SSIS 2008 version and the excel is .xlsx CREATE TABLE Sheet1 ( Date DATETIME, NMMO NVARCHAR(30), P1 # NVARCHAR(30), P2 # NVARCHAR(30) )

but when i see the excel sheet, it gets created but the # symbol is replaced by . I have used P1 '# but it does not make any difference. Is there any way i can retain the column names in excel as it is? Please Help

Related Questions

Copy Logo to excel SSIS Script

Updated January 15, 2018 04:06 AM

Change SSIS package location

Updated June 20, 2017 23:06 PM

SSIS Error on cryptographic error

Updated April 24, 2018 19:06 PM

Office Upgrade from 2007 to 2013 on SSIS Server

Updated October 22, 2017 15:06 PM