Thursday, May 28, 2009

SQL Server 2005: Importing from Excel error 0xc020901c

Error 0xc020901c: Data Flow Task: There was an error with output column "Agenda 2" (63) 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.".


To fix the problem

  • To change the value of TypeGuessRows, use these steps:
  • On the Start menu, click Run. In the Run dialog box, type Regedt32, and then click OK.
  • Open the following key in the Registry editor:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
  • Double-click TypeGuessRows.
  • In the DWORD editor dialog box, click Decimal under Base. Type a value between 0 
  • Click OK, and then exit the Registry Editor.

http://support.microsoft.com/kb/281517/EN-US/

No comments:

Post a Comment