Anyways to insert multiple rows into sqlserver?

Question

I am dealing with some sort of daily data and I need to parsing those data out from txt files and save those into sqlserverdatabase. What I did right now is just to read from those txts line by line and insert into tables. But the problem is, for each single day, it has more than 2 million rows which is really time consuming.

I am just wondering, are there any ways I can make it more efficient? Any suggestion is welcome.

Ps. I am using C#

Thanks,

John Wiese · Answer

If you haven't watched the video the part of interest begins around the 4 minute mark. In older SQL Server version we had DTS Data Transformation Service packages. What these allow you to do is say in every row field A can be filled with the characters from position 1-15 on the line and Field B uses characters 16-20 etc. I think this is what you are looking for so I definitely would look at DTS or SSIS.

Yili Li · Answer

It's fine in sqlserver side. But what I want to know is that is there anyways I can insert multiple rows one time into database in C# side rather than reading one line and inserting one line all the time. Thanks

Yili Li · Answer

Thanks for your replying. What I can do from the txt data is to get it's substring from a particular point to another since there is no specific sign to split out the segment I need.

John Wiese · Answer

http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=87654