Import IIS log into SQL Server 2008 error
- by Vivek Chandraprakash
I'm trying to import IIS logs into SQL Server 2008. I get this error below.
Error 0xc02020a1: Data Flow Task 1:
Data conversion failed. The data
conversion for column "cs(User-Agent)"
returned status value 4 and status
text "Text was truncated or one or
more characters had no match in the
target code page.". (SQL Server
Import and Export Wizard)
I tried changing the column width of user agent to varchar(8000) and nvarchar(4000)
no luck. pls help
-Vivek