Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Copying three tables; from one server to another.

Posted on 2007-11-20
1
Medium Priority
?
156 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

564 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