Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ErickTreetops
Starting Member
1 Post |
 Posted - 2009-03-30 : 00:05:20
|
| I have deployed a package to sQL server 2005.When I run it manually it succeeds.When I schedule it (packaged security is server storage) and use the "start job at step" options i get a success when infact the package has failed with this errorStarted: 1:41:24 PM Error: 2009-03-30 13:41:41.05 Code: 0xC002F304 Source: Web Service Task 1 Web Service Task Description: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The input Web Services Description Language (WSDL) file is not valid. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil..ctor(Object connection, String downloadedWSDL) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 1:41:24 PM Finished: 1:41:41 PM Elapsed: 16.391 seconds. The package executed successfully. The step succeeded.Running the package directly does not cause a problem with the wsdl file. I think the job can't find it but don't understandy why?i'm assuming the wsd file is a resource of the package. How can the package execute fine but when scheduled can't find some of the resources.regards |
|
|
|
|
|
Scheduled Job can't find resource