无法使用C#将数据导入SQL Server数据库

我想将它用作“修复表”,在其中我将添加更多带有数据的表,我总是会收到错误,我无法理解为什么.

错误是

Message – System.Data.SqlClient.SqlException (0x80131904): Unclosed quotation mark after the character string ‘ΧΥΜΟΙ ΑΧΛΑΔΙΩΝ ΤΗΣ ΠΟΙΚΙΛΙΑΣ ‘. Incorrect syntax near ‘ΧΥΜΟΙ ΑΧΛΑΔΙΩΝ ΤΗΣ ΠΟΙΚΙΛΙΑΣ ‘.

描述是希腊语,我不知道这是否与错误有关.

我的代码到目前为止

private void startBtn_Click(object sender,EventArgs e)
{
     string sqlQuery = DatabaseTables.KodikoiTaric;

     if(checkBox1.Checked) 
          InsertDefaultValues(sqlQuery);
}

void InsertDefaultValues(string tableName)
{
    RepairTable(tableName);
    // DataTable csvData = GetDataTabletFromCSVFile(DatabaseTables.taric2);
}

void RepairTable(string tableName)
{
    try
    {
        string sqlConnectionString = Parameters.Config.ConnectionString;
        string script = tableName;
        var sqlqueries = script.Split(new[] { "GO" },StringSplitOptions.RemoveEmptyEntries);

        SqlConnection conn = new SqlConnection(sqlConnectionString);

        SqlCommand cmd = new SqlCommand("query",conn);
        Server server = new Server(new ServerConnection(conn));

        conn.Open();
        var progressBar = 10;

        foreach (var query in sqlqueries)
        {
            progressBar += 10;
            cmd.CommandText = query;
            cmd.ExecuteNonQuery();
            conn.InfoMessage += delegate (object sender,SqlInfoMessageEventArgs e)
                {
                    FileStream ostrm;
                    StreamWriter writer;
                    TextWriter oldout = Console.Out;
                    string _dbUpdateLogPath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + @"DBUpdate" + DateTime.Now.ToString("ddMMyy") + ".txt";
                    try
                    {
                        if (!File.Exists(_dbUpdateLogPath))
                        {
                            ostrm = new FileStream(_dbUpdateLogPath,FileMode.OpenOrCreate,FileAccess.Write);
                            writer = new StreamWriter(ostrm);
                            Console.SetOut(writer);
                            Console.WriteLine(e.Message);
                            Console.SetOut(oldout);
                            writer.Close();
                            ostrm.Close();
                        }
                        else if (File.Exists(_dbUpdateLogPath))
                        {
                            ostrm = new FileStream(_dbUpdateLogPath,FileMode.Append,FileAccess.Write);
                            writer = new StreamWriter(ostrm);
                            Console.SetOut(writer);
                            Console.WriteLine(e.Message);
                            Console.SetOut(oldout);
                            writer.Close();
                            ostrm.Close();
                        }
                    }
                    catch (Exception ex)
                    {
                        NLogger.NLogger.LibraryLogClass.Error(ex.ToString());
                        return;
                    }

                };
            }

            conn.Close();
    }
    catch (Exception ex)
    {
        NLogger.NLogger.LibraryLogClass.Error(ex.ToString());
    }
}

我有文件作为资源文件,表单是这样的

SET NUMERIC_ROUNDABORT OFF
GO

SET ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL,ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS,NOCOUNT ON
GO

SET DATEFORMAT YMD
GO

SET XACT_ABORT ON
GO

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

BEGIN TRANSACTION
GO

DELETE FROM [dbo].[KodikosTaric]
GO

SET IDENTITY_INSERT [dbo].[KodikosTaric] ON 

INSERT INTO [dbo].[KodikosTaric] ([Id],[KodikosTaric],[KoinotikonMetron_a],[KoinotikonMetron_b],[Perigrafi],[DasmosTritonXoron],[ProtimisiakosDasmos],[SimpliromatikesMonades],[YpologismosKila],[DiasafistisId]) 
VALUES (1,N'8701100000',NULL,N'ΕΛΚΥΣΤΗΡΕΣ ΧΕΙΡΟΔΗΓΟΥΜΕΝΟΙ',NULL),(2,N'8701201000',N'ΚΑΙΝΟΥΡΓΙΟΙ',(3,N'8701209000',N'ΜΕΤΑΧΕΙΡΙΣΜΕΝΟΙ',NULL)
      .
      .
      .

总是给我错误的那条线就是这个

INSERT INTO [dbo].[KodikosTaric] ([Id],[DiasafistisId]) 
VALUES (782,N'2009809711',N'ΧΥΜΟΙ ΑΧΛΑΔΙΩΝ ΤΗΣ ΠΟΙΚΙΛΙΑΣ GOYAVES',NULL)

它在哪条线上无关紧要.我尝试将它放在文件的第一行,它会抛出相同的错误.

有趣的是,如果我从SQL Server Express导入该文件作为查询它很有用.

编辑：
感谢@Chris J,我开始理解这个问题.
所以问题是在文件中有这个词

GOYAVES

当我分割文本时,它将其视为GO而不是GOYAVES.我试图改变split命令

var sqlqueries = script.Split(new[] { "nGO","ngo" },StringSplitOptions.RemoveEmptyEntries);

我不再有例外,但问题是即使它似乎工作和拆分更正sql文件它不会写任何东西到表.

编辑2：
我从sql脚本中删除了这些行

SET NUMERIC_ROUNDABORT OFF
GO

    SET ANSI_PADDING,NOCOUNT ON
    GO

    SET DATEFORMAT YMD
    GO

    SET XACT_ABORT ON
    GO

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
    GO

    BEGIN TRANSACTION
    GO

一切都很好.谢谢大家的帮助