I found a fairly simple approach here, but I also like your script task. I'll look into script so I can learn more...after I get this package done. Thank you!

I like your reformat. Looks like the query actually works except for some difficulty comparing "real" with "float" data types.

Looks like I have it under control. Thanks for the...

My plan is to do an "Upsert" using the new "Merge" statement. Haven't gotten to it yet....

Anybody?

It's a left join, so there will be I rows without L rows. In that case, I'm done, and need only one message ('Adding New PO Line to CPAS'). This...

Interesting...

...What's a large amount of data? In this instance, there are maybe 20,000 rows in each table, maybe 100 rows per BoMID in tblBoMDetail. On average,...

Thank you, Keith. That fixed the syntax error. I fixed a couple more that showed up then, now all I have to do is get it to do what I...

Thanks for your reply. I determined the job is getting "access denied". I've troubleshot that as far as I can. It's in the hands of the IT folks now.

Koen, do you have any references I could read to get me started? It is SS2012.

Perfect. Worked like a charm. Thanks

I'll look into it.... Any references you recommend?

I will watch it. I suspect the AllLaborInput table, which is partially replaced every week, my be causing problems. The proximate issue is solved, however.

Thanks

Thank you.

Well, I waded into the issue and decided it had to be a lock problem. I found (after a long period of blind scrambling...) that my backup job from the...

Never mind. I'm an idiot. I did not realize (since the subject instructions referred to a db on localhost) that BOTH the changes needed to be made, not on the...

John and Gail both referred me to the same resource. But I think the maintenance plan I included in the link shows that I do back up the log...every time...