Solved

Copying three tables; from one server to another.

Posted on 2007-11-20
1
149 Views
Last Modified: 2010-03-19
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?

Thanks
0
Comment
Question by:halifaxman
1 Comment
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20318798
... it's a database. Everything can be done :-)

1. & 4. If you have the SSIS package that did the trick for you, just schedule them in a job for the 1st of every month. ... but it looks like you need to create the 'additional' packages first. You now created the 'initial' packages. (see 2)
2. you need to create either a new package for this purpose, or do it using a linked server and a simple join SQL statment (I would recommend that !)
3. Enable database mail  from the surface area configuration and use the Notifications option to send an email on job failure/success/completing.

Hope this helps ...
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
spx for moving values to new table 5 74
Query - which index being used? 2 55
how many extra RAM for SQL server is needed 22 40
Caste datetime 2 57
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question