Solved

Copying three tables; from one server to another.

Posted on 2007-11-20
1
152 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

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

696 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