I have a simple update statement that updates about 200k records in a single table with data from another table in the same DB. I have that update statement in an Execute SQL Task in my SSIS package. If I run it locally or on the server I never get a response
of any kind. I can see by looking at the records that the update is done by SSIS never does anything. If I run the query in SSMS it takes 9 seconds to run. I have optimized it as much as possible and have added necessary indexes. I have been working with SSIS
packages for a few years now and have not run into anything like this before. The SSIS package has another execute sql task, then a data flow task, then the problematic execute sql task. Any ideas on what it could be?
View Complete Post