error converting data from flat file to excel destination

  • I am converting data from flat file to excel destination.

    The flat file source is type DT_TEXT . I cannot change the Flat File source Error output column type or delete it .

    I get this error Error5Validation error. Data Flow Task: Data Flow Task: The data type for "output column "Flat File Source Error Output Column" (33)" is DT_TEXT, which is not supported with Unicode files. Use DT_NTEXT instead and convert the data to DT_TEXT using the data conversion component. Package.dtsx00

    any help is appreciated.

  • Excel destinations can only accept unicode data. You will have to convert your text file data to unicode first.

  • How do I convert this data to unicode?

    I am using column separator as $.

    Salary income $ 656.00

    Total Cash income $ 656.00

    Taxable income for the pay period $ 656.00

    Pensionable earnings for the pay period $ 656.00

    Insurable earnings for the pay period $ 656.00

    Federal tax deduction $ 20.41

    Provincial tax deduction $ 6.71

    Total Tax deductions $ 27.12

    CPP deductions $ 25.25

    EI deductions $ 11.68

    Total Deductions $ 64.05

    Net Amount $ 591.95

  • invaliddba (8/30/2011)


    How do I convert this data to unicode?

    Data Conversion Task in your SSIS dataflow.

Viewing 4 posts - 1 through 3 (of 3 total)

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