jackjohnson44
asked on
SSIS Package I need an exact copy of 7 tables each night
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.
Thanks!
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.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please in SSIS, drop that object and create new using maintenance tasks.
That is an option also when creating the original package through Import Wizard. It is on the right-hand side of the dialog I spoke of next to the 'Delete rows..." option.
ASKER
I found that option and it looks like it will work.
Patel, I am not following, can you please explain?
Patel, I am not following, can you please explain?
ASKER
How can I schedule that this package be run?
You can use SQL Agent to schedule a SSIS step to run automatically.
http://msdn.microsoft.com/en-us/library/ms141701.aspx
I don't do this a lot because of old habits. It is why I said linked server in the other question as that was what I used to do, though probably could have done the same with DTS but just liked writing the SQL myself. *laughing*
http://msdn.microsoft.com/en-us/library/ms141701.aspx
I don't do this a lot because of old habits. It is why I said linked server in the other question as that was what I used to do, though probably could have done the same with DTS but just liked writing the SQL myself. *laughing*
ASKER