SQL Server Performance Forum – Threads Archive

The package execution failed

When I execute the package from the Management Studio, it runs fine, everytime. When i schedule a job to execute it, it fails, everytime. "The package execution failed. The step failed." I have made sure that the package and job ran using credentials with more than enough access infact it is administrator user. Still, with no luck.
—————————————-
http://spaces.msn.com/members/dineshasanka

---

In SQL 2000, you can specify a dump file for the results of each job step (Advanced tab of the step’s properties) where any error messages get printed, same as on the Messages tab of QA.

---

In advance tab there is no place to enter a dump file —————————————-
http://spaces.msn.com/members/dineshasanka

---

Are you looking at the scheduled job itself? In SQL 2000 EM: Server
> Management
> SQL Server Agent
> Jobs
… open the job …
> Steps
… open the step …
> Edit
> Advanced
> Output File

---

Thanks, But i need this in SQL Server 2005. this is working fine in SQL Server 2000 —————————————-
http://spaces.msn.com/members/dineshasanka

---

In SQL 2000, sp_add_jobstep has a parameter for the output file – perhaps it is still available in the SQL 2005 equivalent, just not in the EM dialog?

---

Done fromhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=231863&SiteID=1 says
Keep in mind that every time you conigure or re-configure a step which refers to a package
with a pwd you must re-enter your pwd, e.g. when you configure the "On success action". —————————————-
http://spaces.msn.com/members/dineshasanka

---

I’ve learned my lesson about "printed", that’s for sure.
Scuba Diving Egypt – Hostels world

---

]]>