title: How Do I Copy and Overwrite a Database in SQL Server 2005 with SSIS?
body: <p>I HAVE to be missing something really simple here!</p>
  
  <p>I have a database in my development environment called Project.
  I have a database in my test environment called Project_UAT.</p>
  
  <p>I've created an SSIS package that successfully copied my database from Project to Project_UAT. I'm pretty sure this eliminates most permission and configuration issues.</p>
  
  <p>Now, I want to re-create the package and this time allow it to overwrite the destination, which is Project_UAT. This is simply because from time to time I want to click a button in the Microsoft SQL Management Studio that pushes the new database schema, data, users, and everything, out to my testing environment. I WANT to overwrite the data.</p>
  
  <p>So I create the package just like I did before, but this time I specify the already-existing database name as the "Destination database" and I select the radio button called "Drop any database on the destination server with the same name, then continue with the database transfer, overwriting existing database files."</p>
  
  <p>I click Next, and what does it tell me?</p>
  
  <p>"Database name already exists at destination"</p>
  
  <p>Well, I KNOW! I just told you I want to overwrite it!</p>
  
  <p>How do I make this work?</p>