Anyways to insert multiple rows into sqlserver?

Yili Li

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,

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

John Wiese16y ago
Accepted 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.
0
Yili Li16y ago
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
0
Yili Li16y ago
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.
0
John Wiese16y ago
http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=87654
0