I've been working with SSAS for a year now and for 2010 my goal is start learning SSIS so that I have more control over our development lifecycle where I work. Not to mention, it would make be more marketable in the long run. I know there are a lot of sources available but I'm interested in hearing from others on how they learned SSIS and was it though a class, online course, and by who. What are the best options out there based on actual experiences is what I'd like to know. Any feedback would be appreciated.
Now, I'm completely bias since I own the company but pragmatic does online SSAS training, SSRS training and SSIS training (http://www.pragmaticworks.com/Services/Training/). All the classes are live and recorded for later consumption by authors in the BI Field. You can also get in person training at SQL Share or videos at SQLShare.com as well.
I learned by simply being 'thrown into the fire' - and I did this while SQL 2005 was beta/CTP. I would say that this was a fun way to learn, but not efficiant. I spent a LOT of time doing things wrong only to start over or redesign.
I have not taken any Pragmatic training but it seems to be a pretty good deal - I have signed up one of my develpers for the SSAS training with them.
I started with DTS and then just had to work out how to do things myself. The learning curve was definitely there for SSIS, but there were a lot of changes as well that made some things easier. So mine was mostly a trial by fire with a lot of help from internet searches and various sites. (I also won a copy of Brian's 2005 book that was helpful at times.)
I don't know how you work, but reading books helps me understand some of the theory and gets me started, but I start really learning by getting my hands on. Perhaps if you were to attempt to design something that is needed in your job you could see how things work together. I'd at least try working through some of the SSIS tutorials that you can download from Codeplex. Those are helpful to get started. And ask questions if you're having trouble figuring something out and can't seem to find an answer or example.
You may also want to look at other sites as well as this one - sqlis.net (successor to sqldts.net, IIRC). You can check former articles @ sqlservercentral.com as well. I've seen some SSIS articles and blogs here so it's worth perusing those. Is there a specific task that you'd like to get done right now where we could help you get started?
Personally I'm really visual person. I really learned a lot from the videos at www.sqlshare.com.
Like Brian said, I may be completely biased, but Pragmatic Works does offer training. Just thought I'd reply to post a link of what a third party had to say about the training we offer.
Some of my subordinates attended Brian's SSIS training and were really impressed with the hands-on approach. I have not personally been to their official training classes, but I learned through trial-by-fire in our Data Warehouse project. However, we took a training/development approach to our Data Warehouse project that made that very practical and in fact something I would recommend. We chose to take our entire team through the Pragmatic Works Data Warehouse Fastrak. As soon as the Fastrak was over we identified the shell for our Data Warehouse and had Adam from Pragmatic come in and lead us through various sprints. In those sprints we designed as a team (with Adam's leadership) and developed SSIS packages as pairs within the team. I guess you would call this approach the controlled trial-by-fire approach because we were in the fire of having to produce the Data Warehouse on a particular schedule, but we had Adam onsite with us on a scheduled basis to teach us how to do that with OUR data.
Thanks for all the replies. I actually did my SSAS training with Brian in Orlando, FL and it was great (higly recommended). I like the trial by fire example. I do work with a very good SSIS developer so for now he's my best option until another opportunity arrises. Thanks again.
I learned SSIS through trial by fire at work, with books and most helpfully, through Brian's videos on SQLShare (they are also available on SQLServerCentral.com). I like the videos because you get a complete visual of the process and they are short--usually around five minutes. Perfect for learning one particular skill to get you to your next headscratcher :)
As others have mentioned. I learned when we upgraded and had to choice. Many of our DTS packages were easier to re-write in T-SQL into stored proceedures.. some had to go the SSIS route. I watched the videos for a couple days at SQLShare then picked up the SSIS in 24 hours book. I read some of it but really just went through the video tutorials on my laptop and did every example in BIDS alongside the video.
Now I want a SSAS and SSRS in the same format!
www.appdev.com and www.trainingspot.com have decent video's too.
But from what I hear,Pragmatic Work's training is far superior.
Disclaimer: I am not affiliated to this either of the Sites.
Paul I'm glad you liked the book. We talked with the publisher about writing similar books for the other formats because it became so popular but they want to wait for the next SQL Server release.
Start with http://www.amazon.com/Knights-24-Hour-Trainer-Integration-Programmer/dp/0470496924/ref=sr_1_1?ie=UTF8&s=books&qid=1261518264&sr=8-1
I am picking my way through each of these books and am pleased with them all. The videos in the 24 hour trainer are the best starting point....
I actually helped with the tech editting for Knight's 24 Hour Trainer so I've read it front to back several times and it's a very complete and well rounded approach to learning SSIS.
As many have already mentioned, I also took Brian's End-To-End SSIS class a year or so ago and was very impressed. Unfortunately, production demands in our old SQL2000 servers kept me busy with DTS projects when I got back. By the time I actually STARTED something in SSIS, I found myself scratching my head asking.. 'I know we talked about in class..' My best resource at that point was to refer to either of Brian's books on SSIS (Professional and Expert SSIS) and the vids on SQLShare (JumpStartTV at the time).
IF you can work it out, I really like how one of the last posts did it.. Take the class then have someone come to YOUR shop and walk you through a pilot project with your data and your business rules. We did that with SSRS way back when with a local consulting company.. and that gave us a good jump start on things.
My company hired pragmatic works. (MikeDavis was the trainer)
Even though, I would have liked to see them cover more advanced topics & performance tuning, it does give you a solid foundation & well rounded intro to ssis. Mike is a super patient guy. I would definitely recommend them.
May be because of MVP aspirations or other reasons, there are a lot more people sharing their knowledge in sql server community than Oracle & DB2. So you will find a bunch of online video tutorials like the ones mentioned in the thread, which should jumpstart your learning curve.