Problem running an SSIS Package in SQL Server Agent in SQL 2005
Posted on 2009-04-27
I'm not sure what is going on. I have created a package in Visual Studio which uses a query to extract some data from one of my databases and puts the data in a flat file. You can run debug and the package executes without issue. I then using the Save Copy of Package As .dtsx, I save the package into SQL. I can then log into the Integration Services part of the Management Studio and browse to the saved package, right click and run the package with no issue.
The issue comes into play here. When I go into Management Studio into the Database Engine and I try to schedule it to run SQL Server Agent the package will never run. It just errors out. I have configured it to use Windows Authenication, just as all my other working jobs are setup, but it still doesn't work. And while it say to see the history log, I'm not exactly sure what it is speaking of, but I haven't seen anything to speak of in what I think are the logs.
Does anyone have any idea as to what is happening?