Home Forums Data Warehousing Integration Services Data type conversion error Money-> text in excel destination RE: Data type conversion error Money-> text in excel destination

  • August 16, 2012 at 9:17 am

    #1526659

    2.1 Formatted ID column as a number with no decimal spots, data type: double precision float [DT_R8]

    2.2 Formatted Money column as currency with 2 decimal spots, data type: currency [DT_CY]

    Hello Mordered, thank you for your reply.

    How did you set that currenct[DT-CY] data type??