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-07-19 : 07:05:27
|
| Michele writes "I have a file which contains 1 header row (that contains data) followed by numerous rows of detailed data. The data is not delimited but I know the length of each field. I am wanting to use DTS and create a bulk insert task to load the data from the file into staging tables. I am using SQL Server 2000 and Microsoft Windows 2000. Anything I find on Bulk Insert seems to suggest that the columns need to be of equal width is this true or is there a way of specifying the start position of each column? Is it also possible to extract the data from the header row as well?Any help is really appreciatedCheers" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Can you import a fixed format file using Bulk Insert? 