August 30, 2011 at 9:42 am
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.
August 30, 2011 at 10:51 am
Excel destinations can only accept unicode data. You will have to convert your text file data to unicode first.
August 30, 2011 at 1:00 pm
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
August 30, 2011 at 1:09 pm
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