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.
精彩评论