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 |
|
rtpnc
Starting Member
19 Posts |
 Posted - 2008-10-21 : 16:30:06
|
| Well we have a fixed width file we are trying to Import into a SQL 200 db with DTS. The file is 2398 characters long and I did not realize this until I got to character 2000 on the import wizard and the red line not letting us define any more fields. What can we do to import this into our SQL 2000 db? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-21 : 16:38:46
|
| Do you mean the file is 2398 characters long and it's all for only one record?Maybe there are more records and the config for newline in your dts-wizard is wrong.Planning replaces chance by mistake |
 |
|
|
rtpnc
Starting Member
19 Posts |
Posted - 2008-10-22 : 09:35:27
|
| yea the file is 2398 characters long.But there are many records after it. 40 thousand or so.How do I change the config to accept more than 2000 characters?Thanks |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-22 : 10:16:18
|
| I have tested import wizard with recordsize (not filesize) much greater than 2398.The "red line" was always ok.So I think it's possible that in your file is a carriage return/new line at column 2000 or 2001 so the wizard gets confused...I don't know about any possible configuration to limit the recordsize to 2000.SorryWebfredNo, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Fixed Length Problems Help.....