Number formating issue with Excel Destination in SSIS


  • Hi All,

    I am exporting data from SQL Servre to EXCEL using Excel Destination. While exporting to Excel the numbers are automatically convert to text.

    I want it to be number. I have tried changing the properties data type of column from advance editior and also tried the data conversion task but no luck

    please let me know if there is any work around to fix this issue.

    Thanks for your help!

    Friday, November 01, 2013 12:18 AM


All replies