Solved

Copying three tables; from one server to another.

Posted on 2007-11-20
1
151 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.

726 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