February 11, 2010 at 4:41 pm
Hi,
I'm just in the throes of learning SSIS and wondered if there was a website containing practice exercises I could do to familiarise myself with the product. With questions like, "You need to create a package that extracts matching data from T1/t2 etc, what components would you use and how would you configure them?"
Thanks,
Jake
February 11, 2010 at 11:19 pm
The best way to learn SSIS is to use it. I learned SSIS by using it to replace a DTS process written by my predecessor. The DTS process was written such that the package had to be modified each time it was used. I loaded SQL Server 2005 on my desktop and used SSIS from there to load the same SQL Server 2000 tables that the DTS process loaded.
It was a good learning experience and it was something used at work for a year before it was no longer needed.
Look around where you work and see if you can find a simple use for it and go.
February 12, 2010 at 11:20 am
Appreciated!
February 12, 2010 at 11:34 am
Check out this link.....
I learned SSIS by using training videos from Learnitfirst.com. They were structured from easy to difficult and each lesson built on the next. It was definately worth the investment and your employer may want to purchase the series for you.
Karen
February 12, 2010 at 11:48 am
There are great tutorials in the SQL Books Online.
and it is free, and should already be loaded when you installed SQL Server.
Andrew SQLDBA
February 12, 2010 at 11:52 am
I only counted one on BOL, that's the walkthrough where you create a package to do a straight csv-db copy for two columns, and lookups for the other two, with the error handling and whatnot. Which I already did.
February 15, 2010 at 5:55 am
Try to get your hands on the book "Professional Microsoft SQL Server 2008 Integration Services" from Wrox.
It provides you with a thorough overview of SSIS, together with a lot of examples and cases. (you can skip chapters if you want, it is quite a lengthy book)
I used this book in the beginning to learn SSIS and now it sits on my desk for the occasional lookup.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 16, 2010 at 7:09 am
My suggestion:
Download SQL Sercver and SSIS from Microsoft website.
learn the concept of each control flow tasks and data flow task in BIDS integration service project(when and how to use them).
practice to make SSIS package ( simple to complex).
use google to find blog, link, webcast, video.
learn the concept of variable and expression(It is very essential when you get a SSIS job).
I used the following link in the past:
http://www.sqlshare.com, http://www.sqlservercentral.com, http://www.databasejournal.com, Professional SSIS 2005, Brain Knight's 24 hour Trainer.
Also, there are some white papers and tutorials in MSDN. You need to download Adventureworks database to practice these tutorials.
Hope it will help you.
February 16, 2010 at 8:39 am
I think the best practice for learning a variety of things is to troll forums like this one (or the SSIS one) and answer questions. Figure out how to solve issues that people ask, even those that are answered.
Be sure you can do the basics, for which a book is great. It will get you moving in a basic way
February 16, 2010 at 12:50 pm
Steve Jones - Editor (2/16/2010)
I think the best practice for learning a variety of things is to troll forums like this one (or the SSIS one) and answer questions. Figure out how to solve issues that people ask, even those that are answered.Be sure you can do the basics, for which a book is great. It will get you moving in a basic way
Actually, that is what I'm doing now 😀
I've already picked up a few things you don't find in books or standard trainings...
Another method is to answer some Questions of The Day here at SQLServerCentral. You'll learn some interesting details and quirks about SQL Server (maybe not necessarily about SSIS, but a good understanding of SQL Server helps alot when developing for SSIS)
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