We have SQL Server & Integrations Services 2005.
OK.. I have been doing a few successful SSIS packages this way. I put out a flat file to a directory folder the Server has access to.
Just built a new one. I ran if from BIDS it works fine. I moved the package to the IS on the Server & created a job agent to run it. It blew up with this very helpful error..
Run SSIS Package through Job Agent..
The job failed. The Job was invoked by User UNIONLEADER\wstephens. The last step to run was step 1 (testprocess).
So I tried running the package stand-alone. it give the error ..
Error: SSIS Error Code DTS_E_ProductLevelToLow. The product level is insufficient to component 'Flat File Destination"
So I took a similar package that runs fine in the job agent. I ran the package stand-alone.. I get similar errors about product level is insufficient.. I run the normal job.. works fine.
I take the package to the bids program do minor changes upload works fine.. I take the package and rename it, and do major changes to remove all but the flat file move, but leave where it is moving it to, and all file connections alone.. Set it up to run in the job agent. I get the original error of the job agent.. "Job failed"
At this point I do not know what to try, or why I get this. A co-worker thinks an upgrade may be leaving the old packages working fine, but now not allowing us the same priviledge we had on any new packages we build.. If so this will be a major melt down, and why are they taking away functionality from their old Servers???