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 |
|
deloiter
Starting Member
2 Posts |
 Posted - 2010-07-23 : 05:35:26
|
| There are a number of us DTS users that are facing a common problem. We download a fixed-width file from the federal government that is 9602 char per row consisting of 1213 columns. We only need to map about 750 columns of this file. We want to import it into SQL Server using DTS.While defining the source file in Text File Properties, we get the error "Could not find the selected row delimiter within the first 8 KB of data" because the row delimiter is after position 9602. This isn't about SQL Server table row size, we aren't even to the destination and this isn't about identifying the row delimiter. The row delimiter just isn't in the first 8000 char because the row is 9602 characters.So the question is this. How do we get the Text File Properties to look beyond the first 8000 char to find the row delimiter?Thanks so much. |
|
|
ramecepa
Starting Member
43 Posts |
Posted - 2010-07-30 : 04:55:53
|
| Hi Bro...Here u goto---->>package-->>disconnectedit-->>click on connections--..>>click textfile properties..>>check column length properties and no of columns |
 |
|
|
deloiter
Starting Member
2 Posts |
Posted - 2010-07-30 : 06:47:52
|
| That's exactly what we ended up doing. We listed he columns lengths (1,1,4,4,2,1,3...all 1213 of them) and then set no of columns to 1213. Thanks for your input! |
|
|
|
ramecepa
Starting Member
43 Posts |
Posted - 2010-08-02 : 04:17:19
|
| KK... |
|
|
|
|
|
|
can't import 9602 char wide source file