Post reply

SQL 2005 SSIS - Export numeric values to Excel

  • January 1, 2010 at 4:42 pm

    #138054

    Newbie to SSIS -

    I can successfully export a dataset to Excel,

    but all values in workbook are text.

    examles =

    "Dept_Number" is ok to be text

    "Tasks_Completed" needs to be numeric, so it can be summed

    I have the DataFlow as

    OLEDB to DataConversion (STR and NUMERIC) to ExcelDestination

    Suggestions on what options I need to set to make column be numeric not text?

    Thx

  • January 2, 2010 at 10:55 pm

    #1098214

    Not sure which way you accomplish this.

    On the Excel Destination, if you select "Table or View" data access mode, when click the "New" to popup the Create "Table window", check the date type, make sure it is Numeric for the "Tasks_Completed" column.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply