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



Change SSIS package location

Updated June 20, 2017 23:06 PM


Office Upgrade from 2007 to 2013 on SSIS Server

Updated October 22, 2017 15:06 PM

Problem running SSIS package remotely using PoSH

Updated April 23, 2015 01:02 AM