Fun stuff with SQL Server
Load text file data into SQL Server table
Last time we have seen how to manipulate text files from SQL Server code using Scripting object. This time we would look at “Read File As Table” operation from a different angle – using BULK INSERT operation. There are pros and cons in this approach. Lets look at them. Advantages: Getting Read more…