BIDS/SSIS Package completes successfully but not executing anything
Posted on 2013-06-05
I have a particular bids/ssis package that I have built and then rebuilt from scratch, the first time I built it was on a 2005 box using VS 2005 against a SQL Server 2005 instance and I just rebuilt it using VS Studio 2010 against the same 2005 DB but the job itself runs on a 2012 DB instance. Hope that second part makes sense. Basically the code for the BIDS is on the 2012 DB box along with the job but the DB connection in the BIDS points to the 2005 instance.
Anyway, in both situations the ONLY way to get it to work is to open the package and run it in debug mode. otherwise, when run as a job, it says it completes successfully but nothing happens. The data never gets inserted into the DB, the file is never moved, etc. Another interesting thing is that in debug it takes about 2-3 minutes to execute but when the job runs it finishes in about 5-10 seconds.
Anyone have any idea what could be going on and/or how I can fix this.