+ Reply to Thread
Results 1 to 4 of 4
  1. Member
    Join Date
    Jun 2010
    Posts
    43

    Certifications
    Comptia A+, Network +, Security +
    #1

    Default SSIS suggestions

    Hi all

    I have been given a task of automating our monthly update scripts. After researching for several days it seems like ssis is the way to go. Just wanted to know if anyone knows of a good book that would lead me in the right direction and secondly if SSIS is the correct way to automate this.

    My task is taking update/insert/delete scripts that currently are run by hand and automate them. So we can run them at night. The scripts stay the same but sometimes the data changes and causes them to fail. We want to be able to separate them into reasonably sized packages, so if something fails(because of data change) then the other packages will still run. Thanks in advance for any advice.
    Reply With Quote Quote  

  2. SS -->
  3. Member
    Join Date
    Jun 2010
    Posts
    43

    Certifications
    Comptia A+, Network +, Security +
    #2
    Left out of post: We are running SQL server 2008 R2
    Reply With Quote Quote  

  4. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #3
    No imporatnt changes really in 2008 to 2008 r2. I suggest Knight's 24 Hr
    Trainner. It's a good intro. This will actually be a pretty simple process for you. Even emailling your team when a package fails will be easy enough.
    Reply With Quote Quote  

  5. Member
    Join Date
    Jun 2010
    Posts
    43

    Certifications
    Comptia A+, Network +, Security +
    #4
    Thanks. I'll get it today!
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks