Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stroek
Starting Member
18 Posts |
 Posted - 2007-10-04 : 15:01:15
|
| Hello All,When I'm trying to import the next file..,[url]www.triooo.be/Screenshots/TestText_NL.xls[/url]I get the next error.Messages * Error 0xc020901c: Data Flow Task: There was an error with output column "SectieTekst NL" (75) 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)I thought it was a problem with field length,but when I set the fields -nvarchar- from 250 to max it still dosn't work.can some one please try this and give me a possible awnser Regards Bart |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-10-05 : 12:00:47
|
| Instead of me downloading this file, can you post how the data in this xls file looks like? |
 |
|
|
stroek
Starting Member
18 Posts |
Posted - 2007-10-05 : 14:10:23
|
| Found the reson and solution,Your data may be truncated to 255 characters if the first 8 records for the field(s) being truncated contain 255 or fewer characters. The Microsoft Excel ODBC driver will, by default, scan the first 8 rows of your data to determine the type of data in each column.Even though you can change the Rows To Scan value in the ODBC Microsoft Excel Setup dialog box to something higher than 8 (but not higher than 16) this value is not being used by Excel. The Excel ODBC driver uses the TypeGuessRows DWORD value of one of the following registry key to determine how many rows to scan in your data:• Excel 97HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Excel• Excel 2000 and later versionsHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel[url]http://support.microsoft.com/kb/189897/EN-US/[/url]Regards Bart |
|
|
|
|
|
|
Tasks Import Data