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 |
|
McGurk
Starting Member
21 Posts |
 Posted - 2010-05-20 : 12:22:49
|
| The package is set up to copy a database from one 2008 sql server to another 2008 sql server. Need to set up a job to do this on a daily basis. I have tried my package in BIDS and installed on the server, fails with the same message each time. Cannot find anything on the web or MSDN documentation that helps. See error below:"SSIS package "mypkg.dtsx" starting.Error: 0xC0024104 at mypkg: The Execute method on the task returned error code 0x80131500 (Detach database failed for Server 'mydatabase'. ). The Execute method must succeed, and indicate the result using an "out" parameter.Task failed: mypkg"Any help would be greatly appreciated! Thanks.McGurkAll that is gold does not glitter, not all those who wander are lost... JRR Tolkien |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SSIS 2008 Transfer Database Task failed