Monday, March 19, 2012

Help needed with importing text files

I have a load (180,000+) of text files whose contents need to go into a SQL server database.
Whats the best way of doing this? Using a c# console program and if so, using FileStream or StreamReader? Or using a feature of SQL server itself. The text files themselves are less that 1k and are literally less than 200 characters.
The problem is, I've tried a WinForm and although I can detect what files are there, as soon as I attempt to open one for reading, everything stops working and won't insert anything to the database.

Try this link to use DTS with BCP(bulk copy). Hope this helps.
http://www.sqldts.com/default.aspx?237

No comments:

Post a Comment