June 27, 2006 at 5:43 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 30, 2006 at 8:00 am
This was removed by the editor as SPAM
June 30, 2006 at 8:17 am
Do any of your packages do network/file operations? If so, does the userid invoking the job have the relevant permissions?
Are you using Logging, and if so, what level of information are you getting? If you can get anything, please post some error messages, and the source for them (although I must admit mounting frustration with SSIS error messages).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply