avdhut.k (10/17/2013)
I cant remove the Merge columns,since this is user requirement.Attached Herewith is excel file for my requirement.
In this First two rows are merged.
My data is exporting correctly,but my problem is numeric data is stored is stored as text.
My user want this in numeric.
If your user wants a pretty formatted Excel file, you should use SSRS instead of SSIS.
Anyway, what is the data type of the numeric column in the SSIS data flow?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP