Eric Weldon
- Total activity 31
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 19
Comments
Recent activity by Eric Weldon-
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...
-
Hi Achin, Are you able to convert the data to NVARCHAR MAX in HANA when inserting it into MSSQL?
-
Also, Collect allows you to pull multiple tables at the same time
-
Yes the replication happens in seconds (it pulls only the changed records every 5 minutes). The initial "large" pull would happen at some off hours time.
-
Hi Guillaume Brochet , Does the "Build" button become available if you click the "Reset" button first?
-
Joseph Flesche - I haven't experienced performance issue when adding auditing to a table - may be worth a try again. If they persist, perhaps Support can help identity any issues. Regarding general...
-
Hey Joe, I was offering an alternative to using triggers. You are correct, the auditing record only gets inserted when a change is made via the front end (regardless if the update is made using exc...
-
Hi Joe, If you add auditing to the table, the #AuditColumn table will tell you which field was updated (when the field is not null). You may be able to leverage that in your procedure to make the u...
-
Official comment Hi Mariappan, DSP has reserved columns names "AddedBy" and "ChangedBy". By Default, DSP will update the fields "AddedBy" with the user id of the person who added the records (if it was added via DS...
-
You may be able to leverage BIML Script to edit SSIS package en mass. https://www.youtube.com/watch?v=-S7DKFIZEDI&feature=youtu.be