SQL Server 2005 SSIS Package scheduling

• mail2vz

  SSC Enthusiast

  Points: 102

  More actions

  July 31, 2008 at 1:28 am

  #210777

  I have created a SSIS package and imported into stored package->MSDB->Maintenance Plan

  I run the package by right click run package-> execute. running, no issues.

  I tried to schedule this package but failed.

  Job Owner: NT Authority\SYSTEM

  The step created for executing the package as

  Type: SQL server Intergration Services Package

  Run As: SQL Agent Service Account (default)

  Package Source: SQL Server (default)

  Server: SGN2RYFH1S (local machine)

  Use windows authentication (default)

  Package: \Maintenance Plans\Server-EDrive.

  Executed as user: ZONE1\Vijay. The package execution failed. The step failed.

  The SQL Server , SQL Sever Agent and Intergration Services are running at my windows account (ZONE1\Vijay)

  I tried the owner to sa but failed...

  Anyone please help (I'm using the SQL server 2005 trial version)

• Maksymilian Mulawa

  Ten Centuries

  Points: 1336

  More actions

  August 4, 2008 at 6:13 am

  #852635

  Have you reviewed checklist provided in 'An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step' article (http://support.microsoft.com/kb/918760)?

  There is quite a few possible scenarios, where you can get 'Executed as user: DOMAIN\USERNAME. The package execution failed. The step failed.'

  What is the ProtectionLevel for your package?

  Have you tried scheduling really basic SSIS ?

  Cheers, Max

  Check-out free open-source utility Sql Server Replication Explorer[/url]