SQL Server Performance Forum – Threads Archive

Scheduling with Sequence container

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

---

]]>