Foreign key column allows 0 in SQL Server from bulk insert

In sql bulk copy, how do I insert a column with a specified value?

When you do your insert into the database use the function ...newsequentialid

MS Access bulk import and insert into SQL Server

First of all read data from Excel sheet...connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/temp/") + "FileName.xlsx; Extended Properties=Excel 12.0;"; DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb"); DbDataAdapter adapter = factory.CreateDataAdapter(); DbCommand...

Exception with bulk insert with remote sql server

Configuring the windows MSDTC service on my IIS server did the trick. ...The following link shows how to configure MSDTC....http://www.deepakkapoor.net/turn-on-msdtc-windows-7/

SQL bulk insert does not insert values properly into table

I'm actually a bit surprised you are not reporting an exception....At any rate, I suspect that (at least part of) your problem is that you need to specify the column mappings....From ...http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopycolumnmapping.aspx...If mappings are not defined—that is, the ColumnMappings collection i...

Bulk insert strategy from c# to SQL Server

You would likely be best off with your #2 idea (i.e. sending all of the 15 - 20 entities to the DB in one shot using multiple TVPs and processing as a whole set of up to 2000 messages)....Caching master data lookups at the app layer and translating prior to sending to the DB sounds great, but misses something:...You are going to have to hit the DB ...

Bulk insert is not working properly in Azure SQL Server

I'd suggest you set ...sqlBulkCopy.BatchSize... to a reasonable amount, instead of inserting everything in one batch. Depending on the data you're inserting, try starting with 10.000 and work your way up or down until you're satisfied with the performance....Edit for some extra clarification: When you consider your batch size, you need to take into...

SQL Bulk Insert in C# not inserting values

I think it would be a very long and messy answer if I commented on your code and also gave pointer sample codes in the same message, so I decided to divide then into two messages. Comments first:...You are using automation to get what? You already have the sheet name as I see it and worse you are doing app.Quit() at the end. Completely remove that ...

SQL Server: Bulk Insert into table with computed column

I created another table without that computed column and bcp worked, just to be sure it is an issue with the computed column. Then I recreated the table (with computed column) with QUOTED_IDENTIFIER set to ON - see Jacob's comment - and it still did not work. But when I started bcp with -q it worked. So thank you, Jacob!

SQL Server index behaviour when doing bulk insert

The question is: how are those indexes updated? For each row I insert? For each transaction?...From a low level point of view indexes are always updated row by row, this is a consequence of the indexes internal data structure. SQL Server indexes are B+ trees. There is no algorithm to update several rows in a B+ tree index all at once, you need to...

How to specify foreign keys between two DataTables in SQL Bulk Copy operation?

SqlBulkCopy... doesn't return the identity values. So unless your table ...A... have another unique column such as a "Code" to allow to perfect a ...SELECT... you will not be able to retrieve the generated identity values....Disclaimer...: I'm the owner of the project ...Bulk Operations...This library is not free but allows to output identity value...