Copying three tables; from one server to another.
Posted on 2007-11-20
I have been using IS to copy three tables from one server to another. I have done this by connecting an OLLEDB source to OLEDB Destination and doing this one table at a time, i.e. changing the table name in the source and destination then executing the package manually, and then doing the same for the next table.
I now want to do the following.
1. Run the package automatically so that all three tables are done at once or in a specified order
2. The tables on the destination are updated with only changes in data that happened over the previous month.
3. When the package runs successfully/fails to email myself and some others so we know whatÃƒÂ¢Ã‚Â€Ã‚Â™s happened.
4. To schedule the package to run on the 1st day of every month.
Is this possible and how can this be done?