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 |
|
lancepr
Starting Member
17 Posts |
 Posted - 2005-06-22 : 10:33:00
|
| I have a client who is sending me a file from an older system. The file is fixed width delimited. The file is 5001 characters long with about 300 fields. I have used DTS in the past to run the import, but when they change the length or add a field (happens about 2-3 times a month now!) it takes forever to to use DTS and manaully mark all those fields for import. I know the length and starting location of every field, how can give that info to DTS so it will import the data propperly?Thanks,Lance |
|
|
|
|
|
Fixed Field Importing