June 27, 2006 at 5:50 am
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
June 28, 2006 at 4:50 am
First of all you need to get more information from the job execution. This explains how: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
June 28, 2006 at 7:55 pm
Hi Jamie,
Thanks for your reply. The problem with my shceduling is, all the packages are executing correctly when I am not executing the packges in hierarchial level(eg: Pacakge1 executing Package2 which in turn executing Package3). I am getting error only if I execute the Packages in the above level. I have tried out executing one hierarchial level(Package1 executing Pacakge2), it worked fine.
Thanks,
Saravanan.W.S
June 29, 2006 at 12:09 am
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply