SSIS Package will not run from SQL Agent . Agent job completes with success
I have an SSIS package that runs successfully from BIDS. When I try to schedule this package from SQL Agent 2008 the SQL job completes with success but the package does not run. The package was build under my domain user and I changed have ownership to a local admin account. The package will not run under the other user only my account.
I do have another package that runs successfully from SQL Agent and have compared both for any differences. Nothing seems to be out of place.
I have verified user permissions on the target folder and all looks well.
How long does the job run?
I had a similar issue a little while back. The package completed successfully (in about 29 seconds) but it didn't do what it was supposed to. It turned out that it had been scheduled but it was only validating the package when it "executed". The Production DBA changedd that one setting (unchecked a checkbox) and, poof!, it ran successfully AND did what it was supposed to do. ;-)
So, check the scheduled job . . . I think that the "Validate Only" is a default.