SSIS Excel Data Source: Text was truncated or one or more characters had no match in the target code page.

Using SQL Server 2005 SSIS to import an Excel Spreadsheet into a SQL Server database. Kept getting this error. [Excel Source [5588]] Error: There was an error with output column “Comments” (5691) on output “Excel Source Output” (5596). The column status returned was: “Text was truncated or one or more characters had no match in the target code page.”.

For the solution to this problem, please see this link

3 Responses to “SSIS Excel Data Source: Text was truncated or one or more characters had no match in the target code page.”

  1. Mihai Says:

    So how the foock did you fix it?

  2. baraholka1 Says:

    Mihai,

    My apologies.
    Please go to the following link:

    https://waxtadpole.wordpress.com/2008/04/28/hello-world/

  3. vivek Says:

    I tried by changing the reg entry but still it doesnt work

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: