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:

  • 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.

Wednesday, May 13, 2009

How to Close Web Browsers

btn.Attributes.Add("OnClick", "self.close()");
will do the trick.
Another alternative is
Response.Write (" < script > self.close() ; < /script >