SQL Server Performance

Scheduling with Sequence container

Discussion in 'SQL Server 2005 Integration Services' started by wssaravanan, Jun 27, 2006.

  1. wssaravanan New Member

    Hi all,

    I have tried out scheduling the package(Package1) in SQL server agent. The package contains an Execute Package Task which calls another package(Package2) containing the sequence container which in turn executes many packages parallely. When I ran this package(Package1) directly without scheduling, it went success, but when I tried to run the package(Package1) after scheduling in the SQL server agent I am getting error "The package execution failed. The step failed.". When I tried out running the package after importing the package in the Integration Service, it went successful. I am getting error only when I tried to run the package after scheduling in the SQL server agent.

    Thanks in advance,

    Saravanan.W.S

Share This Page