Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 SSIS Package scheduling Expand / Collapse
Author
Message
Posted Thursday, July 31, 2008 1:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:39 AM
Points: 7, Visits: 31
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)
Post #544117
Posted Monday, August 4, 2008 6:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 2, 2011 3:40 AM
Points: 212, Visits: 222
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
Post #546037
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse