Server connection of backup task in SSIS

[David Greenberg]

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

[dilipk...@gmail.com]

Here is some tip......
You should be able to create a new connection in the Backup Database Task itself. Try to edit the package on the server itself where you have the database to be backed up instead of on your PC. Try windows authentication if SQL Auth does not work.