I have an SSIS package that I used to copy some tables from one server to another. I need this to update each night. I tried to create a new package with the same name (which overwrote the first) and when I was almost done, it said that rows would be appended to the table. I don't want anything appended, I just need an exact copy.
I already thought that this was done via the SSIS package, and I really can't tell the client that I need to do something else. I would really just like to fix the package or do a new one.
Someone mentioned that there was an overwrite option, but I don't see it.
Also, will it be a problem if the tables already exist? When I started, I had a blank DB.