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



Sundeep,

There are many ways to skin a cat. One of them executing command-line BCP
utility (http://msdn.microsoft.com/en-us/library/ms162802.aspx) 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
approach.

Ilya


"Sundeep" <nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:9741a8cf-6cb5-49b5-8c54-1bcea882e140@xxxxxxxxxxxxxxxxxxxxx
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 C#.net(type
of software)

no bulkinsert can't i have string to string copy


From
http://www.developmentnow.com/g/98_2005_1_0_0_386543/How-to-import-fixed-width-text-file-in-MS-SQL-2000.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/


.