home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,530 of 19,505   
   David Greenberg to All   
   Server connection of backup task in SSIS   
   17 Jun 09 11:58:28   
   
   From: davidgr@iba.org.il   
      
   Hi   
      
   I'm writing a package in SSIS )Visual Studio 2008) that will perform a   
   DB backup task.   
   I've created a server connection and tested it successfully but when I   
   run the package (or the task by itself) I get the following error message:   
   Error: 0xC0024104 at Back Up Database Task: The Execute method on the   
   task returned error code 0x80131500 (The connection "Local server   
   connection" is not found. This error is thrown by Connections collection   
   when the specific connection element is not found.   
   ). The Execute method must succeed, and indicate the result using an   
   "out" parameter.   
   Task failed: Back Up Database Task   
      
   I don't understand the message because there is no connection in the   
   task or in the whole package called ""Local server connection". It gives   
   me no option to enter that (as opposed to building a backup as part of a   
   maintenanse plan which gives me that option as my default)   
      
   I've tried various server connections, the other used without any   
   problem in a previous task but still get the same error when running the   
   backup task.   
      
   Anyone had experiance with this error message before ?   
      
   Thanks !   
      
   David Greenberg   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca