• Error 0xc020901c: Data Flow Task 1: There was an error with output column "LocalLanguageLabel" (18) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".

    (SQL Server Import and Export Wizard)

    This looks like the output column out of the Excel data source (in SSIS) is not configured with the correct text size (or character encoding).

    So what you need to do is go back to the first stage of your Import/Export wizard configuration, and edit the output data-type length/type for the LocalLanguageLabel column.

    I think the wizard takes the first 100 items as a sample to build the data-types, which means there is alot of margin for error.

    />L

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding