Re: How to import fixed-width text file(ragged right) in MS SQL 2005? handcode


There are many ways to skin a cat. One of them executing command-line BCP
utility ( from .net.
This is the fastest. Another is reading a file line by line in .net, parsing
it by character positions and writing to a table. There is also SSIS


"Sundeep" <nospam@xxxxxxxxxxxxxxxxxx> wrote in message
i don't want any wizard system plz.. ,file has to be imported by a user
which has always same format so i need to do coding for that in
of software)

no bulkinsert can't i have string to string copy


Posted via Groups