Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update Else Insert logging
Thats what I was thinking would have to happen. However doing the delta compare would be useless for what I am attempting to do. Which is a data quality check. Well thanks for everyones input- cjhardma
- Post #7
- Forum: Data Management Tools general discussion
-
Update Else Insert logging
There is an option NUMROWSAFFECTED which when set to true, will give me the number of rows that have changed. Currently in my setup it is set to false. So rows affected will be the same as rows processed. So if I change NUMROWSAFFECTED, I will mostly what I am looking for. One problem is, I...- cjhardma
- Post #5
- Forum: Data Management Tools general discussion
-
Update Else Insert logging
In the log file it tells you what has been affected and what was attempted to be sent and the number failed. It does not saying what actually happened. Like if you send 100 records and 50 will be updates. It will have rows affected being 100 and not tell you that 50 where updates and 50 where...- cjhardma
- Post #3
- Forum: Data Management Tools general discussion
-
Update Else Insert logging
During a Update Else Insert (upsert) action to a target. I am wanting to get the ratio or the actual count of the number of records that where updated and the amount that where inserted. I have been reading though informatics documentation and I can't seem to find an answer. I have a feeling...- cjhardma
- Thread
- Replies: 6
- Forum: Data Management Tools general discussion
