文本文件去空行

SqlServer文本导入数据

1.SSMS数据导入导出工具

2.Bulk Insert 参考：Bulk Insert命令详细

3.BCP sqlserver2008不支持UTF8格式导入文件（比较坑）。

去空行工具：

 static void Main(string[] args)
        {
            string root = Environment.CurrentDirectory;

            var files = Directory.GetFiles(root, "*.txt");
            var encoding = new UTF8Encoding(false);

            foreach (var item in files)
            {
                FileStream fsRead = new FileStream(item, FileMode.Open);
                //fsRead.Seek(3, SeekOrigin.Begin);
                var fsLen = fsRead.Length;
                byte[] heByte = new byte[fsLen];
                int r = fsRead.Read(heByte, 0, heByte.Length);
                string myStr = encoding.GetString(heByte);
                //string myStr = System.Text.Encoding.UTF8.GetString(heByte);
                myStr = myStr.Replace("\r\n", "\n").Replace("\r","").Replace("\n","\r\n");

                FileInfo fi = new FileInfo(item);
                var newFile = fi.Name.Replace(".txt", ".tsv");

                File.WriteAllText(newFile, myStr, encoding);
                fsRead.Flush();
                fsRead.Close();

            }

            Console.ReadLine();
        }