Post reply

Need help to learn SSIS

  • November 20, 2009 at 6:38 am

    #137079

    Hi I am a newbie to SSIS technolgy.....Really i am eager to learn it from basics to Advanced...Please suggest me some good websites where i can learn it and share any materials with me,

    Thanks in advance

  • November 20, 2009 at 6:57 am

    #1082183

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

    -Vikas Bindra

  • November 20, 2009 at 7:09 am

    #1082197

    Depending on your experience, the Wrox book Professional SQL Server Integration Services 2005 was the book I purchased and used when I started working with SSIS.

    Best thing you can do really is check out your nearest book store and look at the various books and select the one or two that best fit you and your experience with programming and learn style.

    As for web sites, you may want to look at sqlshare.com. Other than that, not too sure.

  • November 20, 2009 at 7:51 am

    #1082241

    The best possible online resource (other than BOL):

    http://consultingblogs.emc.com/jamiethomson/

    http://www.sqlis.com/

    [font="Comic Sans MS"]--
    Sabya[/font]

  • November 20, 2009 at 8:35 am

    #1082277

    I second the wrox book I use SSIS 2005 but the information is still very valuable because it walks through a whole process very well. for a more conceptual approach, you cna check the Microsoft SQL Server Data Warehouse Toolkit or something like that (not sure about the title sorry...). It's basically based on Kimball's Data Warehouse Toolkit but offers an implementation on SSIS so it really is anchored in the concepts of Kimball's approach and applied to SSIS.

    I basically use these two books a lot. and then if I'm missing a specific piece of information to acccomplish a particular task I use google. but for learning, a book on your lap and you doing exercises is your best bet I'd say 🙂

    Greg

  • September 20, 2011 at 4:37 am

    #1383711

    Yes books from WROX publications are good...

    http://letslearnssis.blogspot.com/

  • September 20, 2011 at 10:09 am

    #1383971

    Lots of good webinars on the Pragmatic Works website & http://www.bidn.com/

    Watching videos I always find helps a lot when you are learning as you can actually see someone developing packages from the get go.

    Everybody is different in the way they learn though 🙂

  • September 21, 2011 at 7:23 am

    #1384477

    See also SQLShare.com. Lots of short, targeted videos on how to accomplish a specific task in SSIS (as well as other areas of SQL Server).

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • September 21, 2011 at 10:19 am

    #1384644

    From personal experience, I find the best way to "learn" something is trial by fire. Start messing around with the new software directly with the project that you plan on using it with.

    If you're using SSIS as an ETL tool, then create a test database, dump your data that you will be working with into there, and then start doing whatever it is you plan on doing. Every time you're unsure about how to do something, go do some searching and find a solution that will handle your problem.

Viewing 9 posts - 1 through 8 (of 8 total)

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