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.
0 Comments
Leave a Reply. |