When I am trying to insert data . I am gettin this error
source--flatfile
intermediate stage --- Transformer
target--sqlserver
SQLServer_Enterprise_346,0: Failure during execution of operator logic.
SQLServer_Enterprise_346,0: Internal Error: (0): odbcupsert.C: 846
can anyone suggest me what the error might be
I am waiting for an answer for long but i got no response so i am posting it again
Help me out on this
Internal Error: (0): odbcupsert.C: 846
Moderators: chulett, rschirm, roy
I guess, its your second post regarding the same issue. i know you havnt got any solution in the previous thread.
As suggested in the previous thread, have you tried to reset the job? Have you got "From the previous run.." log? If so what does it says?
As suggested in the previous thread, have you tried to reset the job? Have you got "From the previous run.." log? If so what does it says?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
one more thing is when I am writing to a file it is writing it
when i do a reject on sql srv plugin the data is good
when i keep an option write mode and repalce option it writes into database
but for upsert and insert only its not
i am not able to trace out what might be wrong
Is there any difference in execution between upsert and write modes
when i do a reject on sql srv plugin the data is good
when i keep an option write mode and repalce option it writes into database
but for upsert and insert only its not
i am not able to trace out what might be wrong
Is there any difference in execution between upsert and write modes
Hi vsi..
There is a difference between upsert mode and write mode...Upsert is used when you want to update the table..(update/insert) and write mode to write...Well say what exactly you want to do whether to update the table else only to write data to the table...
[quote="vsi"]one more thing is when I am writing to a file it is writing it
when i do a reject on sql srv plugin the data is good
when i keep an option write mode and repalce option it writes into database
but for upsert and insert only its not
i am not able to trace out what might be wrong
Is there any difference in execution between upsert and write modes[/quote]
There is a difference between upsert mode and write mode...Upsert is used when you want to update the table..(update/insert) and write mode to write...Well say what exactly you want to do whether to update the table else only to write data to the table...
[quote="vsi"]one more thing is when I am writing to a file it is writing it
when i do a reject on sql srv plugin the data is good
when i keep an option write mode and repalce option it writes into database
but for upsert and insert only its not
i am not able to trace out what might be wrong
Is there any difference in execution between upsert and write modes[/quote]