SSIS training - in depth

  • I have been working with Integration Services for several years, and my boss wants me to get to Ninja-level competence. Anyone have ideas where to go for hardcore, in depth SSIS training? I'm based in Minneapolis.

    Thanks in advance,

    Jason

  • First thought, have you read through all of BOL? Do you have an instance installed where you can play? Does your boss allow you to set aside time for training during your work day/week?

    After that, look for a trainer that you can either attend a workshop (where you get hands-on experience, not just lectures), or have them come to your workplace.

    I know Andy Leonard does SSIS training[/url], I'm sure lots of others do too.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • +1 for Andy Leonard.

    You could also start answering questions at forums. (that's what I did).

    Try answering questions about topics you're not that familiar with. Do some research to find the answer and you'll learn in the progress.

    Recommended books:

    Expert SQL Server 2005 Integration Services

    Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer)

    Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Oh yeah, join your local PASS chapter if you haven't already. Try to go to some meetings, even if the topic doesn't interest you. You might still learn something and meet very interesting people. After some time, you could try to give a session about SSIS yourself. No better way to learn about a subject than to teach it.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Just saw this today, might come in handy: http://bit.ly/arcanessis

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Thanks everyone, great suggestions. I never thought about reading BOL unless I was researching a problem! I'm going to SQL Saturday in Madison in April; I'll look into our PASS chapter here.

  • My personal opinion, BOL is just a reference point, you can't really "learn" how to do things from BOL.

  • NeverDie (10/8/2014)


    My personal opinion, BOL is just a reference point, you can't really "learn" how to do things from BOL.

    There are tutorials though on MSDN:

    SSIS Tutorial: Creating a Simple ETL Package

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks for that.

    In the past (many years ago), I was not impressed with Microsoft's Help with Programming Languages and SQL. Ever since, I've used any other resource except for Microsoft.

    It seems like the "Microsoft Help/BOL" has gotten a whole lot better, I'll have a look at it again and give it a fair chance.

  • NeverDie (10/8/2014)


    Thanks for that.

    In the past (many years ago), I was not impressed with Microsoft's Help with Programming Languages and SQL. Ever since, I've used any other resource except for Microsoft.

    It seems like the "Microsoft Help/BOL" has gotten a whole lot better, I'll have a look at it again and give it a fair chance.

    It's not perfect, but it's quite good in my opinion. As reference material that is.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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