Inserting data to SQL server using Sqlbulkcopy

Question

i'm having a error message sent everytime i try to copy data from a data table to an sql database using Sqlbulkcopy. This is the code i'm using:

static void InsertDataIntoSQLServerUsingSQLBulkCopy(DataTable csvFileData)
    {
        using (SqlConnection dbConnection = new SqlConnection(@"Data Source=DESKTOP-LNCGI78\SQLEXPRESS;Initial Catalog=Testdatabase;Integrated Security=SSPI;"))
        {
            dbConnection.Open();
            using (SqlBulkCopy s = new SqlBulkCopy(dbConnection))
            {
                s.DestinationTableName = "dbo.Table";
                foreach (var column in csvFileData.Columns)
                    s.ColumnMappings.Add(column.ToString(), column.ToString());
                s.WriteToServer(csvFileData);
            }
        }
    }

This is the error :System.InvalidOperationException: 'Cannot access destination table. i checked permissions to write in the table, all seems fine and i tried to insert some rows in it with success. I don't know what i'm missing or what i did wrong.

Possible duplicate of SqlBulkCopy cannot access table

mjwills
– mjwills

2018-10-26 09:51:39 +00:00
Commented Oct 26, 2018 at 9:51 — mjwills
– mjwills, Commented Oct 26, 2018 at 9:51

Sean Pearce · Accepted Answer · 2018-10-26 10:02:48Z

1

The word Table is a reserved word in SQL Server and as such you need to add brackets:

s.DestinationTableName = "dbo.[Table]";

answered Oct 26, 2018 at 10:02

Sean Pearce

1,1705 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ivan Stefner · Accepted Answer · 2018-10-26 10:07:42Z

0

I had a similiar problem what I did is just s.DestinationTableName="[TableName]". So no dbo.[TableName] just [TableName]

answered Oct 26, 2018 at 10:07

Ivan Stefner

321 silver badge6 bronze badges

Collectives™ on Stack Overflow

Inserting data to SQL server using Sqlbulkcopy

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related