SSIS tasks go green very quickly and do nothing

SISS 2008 - My package goes green very quickly, but does nothing. The connections are opened, but nothing is being passed in the connection.

开发者_JS百科

This problem started when I moved from a test environment to a production one. I'm using package configurations to hold the connection data.

---

I put this down to using data sources and not package configurations.

---

I'm wrong - I'm pretty sure it has something to do with the data, as I removed all but one row. Some exception must be occuring that isn't handled by the provider which is why we're getting the strange behaviour.