When we do excel integration(upload some data) where does this temporary data gets stored?
Because we want to do some duplicate check and other things before we commit to the webpage.
Is this for an update of existing records or for an append into the target / destination table? Either way, I do not know where this data is stored, but why not just do your duplicates analysis / reporting in the target / destination table? That way you cover the issues no matter how the data gets into the table.
Hi Sairam,
There is no temporary table that stores the data. Excel Integration will try to insert/update the records as they are and if they fail due to duplicates, the transaction gets rolled back. If you want to avoid duplicates, I would advise filtering the page for the records that you want to insert and/or update and only download those records. I would also recommend having a "natural" primary key on your page so if there is a discrepancy, the transaction gets rolled back and not committed which will prompt and investigation as to why it failed. If you need a surrogate key for construction purposes, you should setup a validation error to check for duplicates based on the natural key.
Surrogate Key vs Natural Key Differences and When to Use in SQL Server (mssqltips.com)
Please sign in to leave a comment.
Comments
2 comments