SSIS Scheduled Package execution log location?

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  June 23, 2011 at 8:04 am

  #253253

  We created a SSIS (2008) package that runs correctly when run interactively. When scheduled it also runs successfully, per the “View History”, under SSMS. But in fact, the scheduled package does NOT produce the results we expect .

  Interactively SSIS supplies a “Progress Log” showing each step of the package execution. Is there a similar log for scheduled jobs (with the same level of detail)? Is so, where is it located?

  TIA,

  Barkingdog

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 23, 2011 at 9:22 am

  #1343144

  No log from SSIS by default.

  You can setup your Agent job step to capture anything the package execution writes to the console.

  Beyond that you'll have to implement your own logging in your SSIS package.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato