Error: 0xC02020A1 at Data Flow Task, Flat File Source 1 [101]: Data conversion failed. The data conversion for column NAME" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

Try solution from below link http://oscarvalles.wordpress.com/2009/10/22/returned-status-value-4-and-status-text-text-was-truncated-or-one-or-more-characters-had-no-match-in-the-target-code-page-sql-server-import-and-export-wizard/Regards, Vishal Patel My Blog

even if i change field length ,it doesn twork my fiels in table has nvarchar(15) , here it comes as dt_str , 50 what lenght it should be for dt_str ,

Right click on your flat file, go to, "Show Advanced Editor" > "Input and Output properties" > "Flat File Source Output"" > "Output Columns" > YourColumnName > Change "Truncate RowDisposition" to RD_IgnoreFAilure

Please check if the length is the same and synchronised in all the below mentioned objects. 1. Flat File Source --> Advance Editor --> Input/Output properties --> Flat File Source Output --> External Columns 2. Flat File Source --> Advance Editor --> Input/Output properties --> Flat File Source Output --> Output Columns 3. Source Connection --> Advance --> Column properties. 4. Table Column properties. Regards, Anjana Shree M.R.

even if i change field length ,it doesn twork my fiels in table has nvarchar(15) , here it comes as dt_str , 50 what lenght it should be for dt_str , If your table has a limit of 15 chars and the incoming string is longer only two options exist: Trim the incoming valueorEnlarge the target fieldArthur My Blog

how to trim incoming field

Well, you need to ensure your business accepts this 1st of all. Trimming is possible with a Derived Column Transformation - replace column setup, in there you can use a SUBSTRING function e.g. SUBSTRING([Column1],1,15)Arthur My Blog

It seems that your target table has data type of nvarchar and size 15. Whereas the incoming data is dt_str format. Therefore, first, you need to increase the size of the column. Secondly, you need to use data conversion task to make into nvarchar data type.hsbal