Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldoubt
Starting Member
17 Posts |
 Posted - 2010-06-30 : 14:08:33
|
| I have a scenario where I am getting data from satging to destination database. This could be in append mode or reload mode.Data loaded using append mode is stored in intermediate table. From there it is sent to destination.Once I get the data I am running a job. But the job is failing and the error log is giving message that upsert failed. I have no idea why the job is being failed.If I delete the data in intermediate table, and run the job, then it is working fine. Else it is failing.Plz help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
sql push job failing