Finding the rows that caused the constraint failure

How do I configure Fire Triggers and Check Constraints in SqlBulkInsert?

Possibilities only, I'm sorry...SQL documentation for ...BULK INSERT... specifies 3 cases where ALTER TABLE is needed. You listed 2 of them. Is the KeepIdentity option being set, even if not needed?...Another option is that the trigger on the table is disabled already, confusing the issue. Use ...ALTER TABLE dbo.SomeTable ENABLE TRIGGER ALL... to e...

Managing a SqlBulkCopy transactional network failure

I'm researching SqlClient's SqlBulkCopy in ADO.Net and have the following questions....What will happen, if there was a network error during a ...SqlBulkCopy... operation, running under as part of a transaction over a huge number of records? ...Will the transaction be left open (neither committed, nor rolled back) in the server, until we manually k...

How to debug Postgres copy command failure

I have around 75k records which I am loading to a Postgres table using copy command which is failing. I get an exception ...ERROR: invalid byte sequence for encoding "UTF8": 0xbd...Now i need to find which line is having this entry. Is there any way to do this? I am thinking in lines of enabling some postgres logging that might help or any other so...

IDataReader implementation failure with SqlCeBulkCopy

Do you have any Numeric values in your import? Sounds like its trying to convert/parse a int and its failing.

Constraints not being enforced (consistently) while using SqlBulkCopy

On our database table we use two unique non-clustered indexes to create a unique constraint across four fields. We use two due to the fact one of the fields, ...ZipCode... is a nullable field. If a record exists on the table with a ...null... entry for ...ZipCode..., we don't want a scenario where a new record matches the three other fields but has...

How does SqlBulkCopy circumnavigate foreign key constraints?

By default CHECK and FOREIGN KEY constraints are ignored during bulk copy operation. SqlBulkCopy is a managed class providing functionality similar to what SQL Server bcp command offers. The bcp command has a ...-h... hint and unless you provide the ...CHECK_CONSTRAINTS... hint the CHECK and FOREIGN KEY constraints are ignored during the bulk load....

Does SQLBulkCopy Upload any data upon failure?

I am doing a sql bulk copy of data from an excel spreadsheet to a temp table, and then from a temp table to a production database. ...My question is this, if for any reason the upload fails either to the temp table or to the production database, does the transaction get rolled back and no data gets imported or modified existing data?

Delete rows from DataTable in memory matching duplicate rows in Database

I have a dataTable which I will use to BulkCopy to a destination table. I am trying to resolve primary key violation. So instead of using a temp table and then merge with production, I am trying to delete the redundant rows from the DataTable in memory before passing it to the WriteToServer method. ...In my code I create the Memory DataTable column...

SqlBulkCopy.WriteToServer(DataTable) row by row: very slow

I had to make application that imports a ...csv... file to database table. The ...csv... files are like ...~500rows...~30columns... and are from not very reliable source (might contain corrupted data)....I did it like this ...CSV->DataTable->SqlBulkCopy.WriteToServer(DataTable).... And it process 500 records to non-local sql server for about ...4 s...

When/how are Constraints Checked in a SqlBulkCopy w/ Check Constraints enabled?

I am performing several ...SqlBulkCopy...'s in a single transaction, I need to be able to roll back easily if anything goes wrong. I'm bulk copying several tables that have foreign keys to each other. I want these constraints checked. I'm copying the parent table first, then the child tables, but I'm receiving foreign key constraint errors. Does ..