Thanks for the response guys. I tried to be as clear as possible but I don't think I did a good enough job. I understand how to update...

Phil, thanks for your help.

Jacob, I marked you as the answer because I learned how to do an error output file thanks to you suggesting it. Remember, I'm a...

Phil - I'm sorta new so thanks for your help.

In both the derived col and conversion, I can not change the value in the Precision box. For the conversion,...

John Rowan (4/13/2016)

---

Why don't you handle this in SSIS before you load the data? An expression on your pipeline column would fix this. The real question is, why...

Thanks ZZartin, that worked perfectly.

This did not work. Gave me the same results.

100% primary and DR

I changed the date convert back and it worked.

UPDATE APF

SET CurrentPX = Moxy.Price

FROM AxysPriceFile AS APF

JOIN (

...

UPDATE APF

SET APF.CurrentPX = Moxy.Price

FROM ...

SSCrazy - Thanks for your help and I'm pretty close. When I execute your code, I get Invalid Object Name 'APF' and I don't know why. When I...

Bueller? Bueller? Bueller?