I would recommend doing a few hands-on-labs to get familiar with SSIS. You can pick the various examples available at the SSIS tutorial at beyondrelational, as well as what you find in various SSIS bloggers that you may have seen on various internet blogging sites.

I think that will be a good starting point. Gradually a strategy can be derived which will occur naturally. I have requested some of the SSIS experts that I know, to visit this thread and share their thoughts on this.

Hands on lab is always the best way to start and I always recommend the MSDN Virtual Labs. You can work on the server that Microsoft provides nand hence, do not even need to install this on your computer. Try this link and let me know if there are any issues

https://cmg.vlabcenter.com/default.aspx?moduleid=355a1cdf-6521-4d88-bd21-a205ebc03f48

Also, it would be advisable to pick up a SSIS book and start reading through it.

Thank you Jacob.

Thank you Jason for the link, will be helpful to us. Any book you would recommend for the one who is new to SSIS.

Regards, Sanjay

Sanjay,

Although there are many good books on SSIS, I don't own more than 3. For a beginner, I'd recommend the following book. This is the only Training Kit book I own. You do not need to prepare for the MCTS Exam to own this book.

Through a series of lessons and reviews, the book covers learning objectives, reinforces and applys the lessons through real-world case scenarios and practice exercises.

The book covers all three Microsoft BI stacks, SSIS, SSAS and SSRS. A third of the book is devoted to SSIS.

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)

http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-448/dp/0735626367/ref=sr11?s=books&ie=UTF8&qid=1345814679&sr=1-1&keywords=70-448

Good luck,

Sherry

Thank you Sherry, I will buy this book. Thank you for response. I also got Wrox one.

Sanjay