July 31, 2008 at 1:28 am
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)
August 4, 2008 at 6:13 am
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 ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply