SQL Server Performance Forum – Threads Archive
The package execution failedWhen 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.
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 —————————————-
Are you looking at the scheduled job itself? In SQL 2000 EM: Server
> SQL Server Agent
… open the job …
… open the step …
> Output File
Thanks, But i need this in SQL Server 2005. this is working fine in SQL Server 2000 —————————————-
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". —————————————-
quote:Originally posted by Adriaan 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.
I’ve learned my lesson about "printed", that’s for sure.
Scuba Diving Egypt – Hostels world