Copying data with SSIS without recreating the tables
<p>I want to copy data from database A to database B.</p>

<p>I created a saved SSIS package successfully and data was indeed copied from A to B. Now I want to automate the process but when I'm launching the saved .dtsx file I get this error:</p>

<pre><code>"Error: Executing the query 
    "CREATE TABLE ... failed with the following error: 
       "There is already an object named ... in the database"..."
</code></pre>

<p>Seems like SSIS is trying to create the table again. How do I set SSIS to copy the data only, without recreating the table?</p>

<p>Ta. </p>