Hi I am using a merge statement in excute sql task to insert and update records. I am capturing the merged records in a variable (mergecounter) with @@rowcount as 'select @@rowcount as count' and then in defining the result set as single row and then mapping the mergecounter variable to resultsetname (count). After that i am using the variable to insert the its value in log table. Now, i want to do exactly same thing but this time ssis points to pl/sql oralce database. Merge is working fine and records are gerring updates in oracle tables. For logging, i am using ' 'select sql%rowcount as count' instead of @@rowcount as i heard that sql%rowcount in equivalent to @@rowcount. I am getting error as 'invalid character'. May be i was too wishfull that same will work with oracle too. Please Advice

In Oracle it would have to be something like select sql%rowcount as count FROM DUALChuck

i have tried that too. still says invalid character (ASCII).