Very strange behavior

Question

HI All,

I have an SSIS package that inserts/updates images(thumbnail) in a product table. One thing I noticed is that "sometimes" the package doesn't insert/update all the images(90% will be inserted/updated). To fix this, all I do is open the package in BIDS and run it and it resolves this issue. Has anyone seen this issue before or any thoughts on how to troubleshoot this? We are using SSIS 2005, SQL 2005

Answer 1

Do you have the logging enabled? There must be something going wrong. Also please share how you process the images exactly.

---

Arthur My Blog