locked
export to existing excel sheet RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have the following problem with SSIS Excel destination in Dataflow task.

    The data from my select query from the data source are mostly of type money (Sales, Average Sales) and float type (percentages).

    The data conversion task turns them to DT_CY or DT_R8 format.

    The receiving excel sheet has the data formatted as Accounting or Currency type.

    I cannot format the added data because they show up as text and prevent the predefined format to be applied.

    I guess that I can reformat the excel sheet afterward by some script task, but I do not have big experience with the excel object model, so if you have any suggestion I will be grateful.

     

    Thanks for your help!

    Wednesday, March 18, 2009 1:21 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
     try using the derived column transformation component instead of the data conversion transformation component.  bear in mind that you will need to use an ssis expression to perform the conversion.

    hth
    Duane Douglas, MCAD | http://www.ssisbi.com | Please mark the post(s) that answered your question.
    • Proposed as answer by Duane Douglas Wednesday, March 18, 2009 5:05 AM
    • Marked as answer by Tony Tang_YJ Friday, March 27, 2009 3:55 AM
    Wednesday, March 18, 2009 5:04 AM