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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-26 : 07:29:21
|
| Shipra Gupta writes "Hi I have a text file having First row as ColumnName second one is the header and the last one is the footer.I want to extract the data from this file into one user table.I am selecting Fixed field option because I dont have a delimiter.1st Column - 2 char2nd Column - 4 char3rd Column - 6 char4th column - 1 char5th Column - 3 char6th Column - Rest characters.Problem:1) If i am using skip rows -2 then out of 90000 records only 2000 are getting processed.2) If i am not skiping any row except choosing the option "First Row has column names" Then it is fixing the width of the last column to (Length of header row)-(2+4+6+1+3)Due to which the values in the last column for all other rows are truncated.I want the last column length to strart from a specified postion(this can be 17 in this case) and should end where row ends.Thanks & RegardsShipra" |
|
|
|
|
|
DTS and Fixed Field Problem