excel text import wizard default settings

The component returned a failure code when the pipeline engine called PrimeOutput(). A truncation error occurred on the specified object of the specified component.Įrror 0xc0047038: Data Flow Task: The PrimeOutput method on component 'Source - Sheet1$' (1) returned error code 0xC020902A. The column status returned was: 'Text was truncated or one or more characters had no match in the target code page.'.Įrror 0xc020902a: Data Flow Task: The 'output column 'English String' (18)' failed because truncation occurred, and the truncation row disposition on 'output column 'English String' (18)' specifies failure on truncation. So, no question here, just posting the bug so that *next* time someone searches the web for an answer, this post comes upĮrror 0xc020901c: Data Flow Task: There was an error with output column 'English String' (18) on output 'Excel Source Output' (9). There doesn't appear to be any 'Advanced' options for the Excel importer as there are for the flat-text importer. We have found no workaround except manually changing the imput data.

We have found that using the SSIS 'Import and Export Wizard' using the 'Microsoft Excel' data source that there appears to be a maximum column length of 255 characters for any row.Įven when defining the destination table columns as nvarchar(4000), the wizard fails with the errors shown below.

Excel text import wizard default settings