SQL Server 2005 SSIS Package scheduling

  • 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)

  • 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]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply