SqlBulkCopy Tutorial - Knowledge Base (KB)

Looping in Trigger?

I got this following scenario,...There are four tables COUNTRY, STATE, CITY, STREET... And I have the excel file with the records of the above..possibly 2000 rows as of now....I used SqlBulkCopy to import the data to a temp table, lets name the table IMPO...

SQLBulk Copy with trigger which fire Update query

I have insert records from excel sheet to SQL using ...SQLBulkCopy.......Code runs fine for me....But I have to fire Trigger based insertion....In trigger I am inserting records in another table based on ...Inserted...that also works fine....but if I am c...

Fire trigger for every inserted row using SqlBulkCopy

I am using ...SqlBulkCopy... class to insert 50k rows at a time in table ...tbl_records... I have set a ...After Insert... trigger on this table and using following code...SqlBulkCopy SqlBc1 = new SqlBulkCopy(strConnString, SqlBulkCopyOptions.FireTriggers...

Trigger not working in BulkCopy in Sql Server

I have an application through which I'm inserting bulk records into a table using SqlBulkCopy. I have a trigger which inserts the records added into the First table into Another table....When I'm inserting i have written SqlBulkCopyOptions.FireTriggers in...

.NET BulkCopy Only Firing Trigger On One Insert

I perform a trigger on each insert on a table. I am using bulkcopy to do a bulk insert into this table. I read FireTriggers will fire my trigger on the table, but it only does it one time, not for each insert. The trigger takes some data from the inser...

Keep log table inserted data in SqlTransaction Rollback C#

I am using SqlTransaction to BulkCopy data to a table in SqlServer database. There are several stored procedures which are called based on column values in inserted table. If there is any error, I am using Rollback to avoid dirty data in tables. I am logg...

SQL Trigger Update to Uppercase doesn't work using SQLBulkCopy Insertion

I'm using .NET ...SQLBulkCopy... to batch insert data into database. What I'm trying to do is to convert all specified string to uppercase when the data is inserted into the table. Here is my trigger script:...ALTER TRIGGER [dbo].[EmployeeTable_UpperCase]...