SQL Server Performance

The package execution failed

Discussion in 'SQL Server 2005 Integration Services' started by dineshasanka, Feb 14, 2006.

  1. dineshasanka Moderator

    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
  2. Adriaan New Member

    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.
  3. dineshasanka Moderator

  4. Adriaan New Member

    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
  5. dineshasanka Moderator

  6. Adriaan New Member

    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?
  7. dineshasanka Moderator

  8. Anonymous New Member

    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

Share This Page