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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2004-12-27 : 13:06:02
|
| Does anyone have a method for space padding records (adding trailing spaces) in a text file?Background: We are receiving a "fixed width" file that is not coming fixed width (despite continuous and agonizingly prolonged efforts to resolve the issue). Each record stops after the last field populated with data (rather than after the last field in the file/layout). Some records have 53 fields, some have 82 (or so)--each record should be 1100 characters in length. In order to import this file properly, all fields need to be accounted for in each record. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-27 : 13:12:12
|
| Import using bulk insert into a single column staging table then move the data to the destination tables.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
adding trailing spaces