Sql Server 2008/SSIS: Transfer Sql Server Objects Failing, No Useful Debug Information Generated
===

I am trying to copy a Sql Server 2008 database from a production server to a development server. I set up a new empty target database, and added a Transfer Sql Server Objects task to the Control Flow pane. I configured the task to use SMOServer connections (both of which test fine). I've tried both copying all objects and copying just the ones I want. I've set it to drop destination objects first, even though there's nothing in the target database.

Yet it refuses to work. And it generates absolutely no error information at all, despite the fact that I have tried to turn on every logging option I can find. All I get is success in the validation phase, a series of warnings that certain classes of objects don't exist to copy (which is correct), followed by a "hang" in the "yellow zone" (i.e., the task box is highlighted in yellow).

How in the world can something as simple, straightforward, and frequently done as copying a database be so darn difficult? What am I doing wrong? Besides using SSIS, I mean :).

<rant>p.s. Sigh. Every time -- every time -- I try to use SSIS to do something that should be drop-dead simple it ends up being a royal PITA. IMHO it's one of the worst-written pieces of development software Microsoft has ever inflicted on the world. I wish whoever is in charge of it in Redmond would come sit next to me one of these times...so he could experience the heat of 10,000 suns worth of anger and frustration :).</rant>