SSIS - Synchronise tables on different db's

  • Hi there, I need some help please. I do not know SSIS and have never had the need to use it yet. I have website on the internet where members can log in and capture there continuous professional development points and I have the same website running as an intranet where admin clerks can capture those members points that do not have access to the internet. Now, I have one table on both databases that I need to synchronise on a daily basis. They look exactly the same. I thought SSIS would be a good call but I don't have a clue where to begin. Anyone willing to help please?! This is rather urgent!

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • A good place to start is with the BOL tutorial. The following links below should also help you out.

    http://msdn.microsoft.com/en-us/library/ms169917.aspx

    http://www.microsoft.com/sqlserver/2005/en/us/integration-services.aspx

    - Costa

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply