Best tutorial to learn SSIS

Question

Hi, Which book is best to learn SSIS. Actually in my project we need to take onput from CVS file and after processing the data in SQL server 2008 we have export it back to excel file. ASP.NET is used as UI for this. Thanks, Nabin

Answer 1

Try this book:

http://www.amazon.com/Professional-Microsoft-Integration-Services-Programmer/dp/0470247959

The best way to learn SSIS is just to do it. Probably best to start and then refer to the book. Because the tool is so GUI intensive, I tended to get more after reading the book later once I was already familiar with the environment somewhat.

Answer 2

I completely agree with Cade in terms of simply working with it. I found that trying to follow specific "tutorials" to try and learn the package didn't really help but having a number of useful resources definitely came in handy.

At work, we had this book kicking around but really it just went over the flow objects available without going into any real-world examples. Jamie Thomson's blogs (here and here) are both excellent online resources though and have been really helpful for me personally.

Answer 3

Hi,

Reading the material some times couldn't solve your real time migration by missing some perticular functionality related to your project. I worked on your scenario case of migrating database to SQL using intermediate CSV or text files.

http://msdn.microsoft.com/en-us/library/dd537533(SQL.100).aspx

we migrated nearly 1TB in 30 min using SSIS 2008.

this could help to get the information on specific properties of souce file according to our requirements.

thanks prav