Scheduling an SSIS Package

• JM-92548

  Ten Centuries

  Points: 1108

  More actions

  December 12, 2006 at 3:40 pm

  #171222

  Im trying to schedule an SSIS package but I keep on receiving errors when I try to execute.

  The error in the job history is: "The package execution failed. The package failed.

  But when I run in the in the BI Studio the package works fine 

  Here are my steps:

  1- In the Sql Agent I create a new job.

  2- Give the job a name

  3- Create a step.

  4- Type: IIS Package

  5- Package Source: File System

  6- Set Schedule

  When I try to run manually I get an error.

  Am I missng a step?

   

   

• JM-92548

  Ten Centuries

  Points: 1108

  More actions

  December 12, 2006 at 4:03 pm

  #677664

  I was able to figure it out.

  In the Sql Server Configuration manager I needed to change the startup to the agent.