The best tutorial for learning SSIS

Question

Which book is best to learn SSIS. In fact, in my project we need to take the stream from the CVS file, and after processing the data in SQL Server 2008, we export it back to the excel file. ASP.NET is used as the interface for this. Thanks, Nabin

Answer 1

I totally agree with Cade that he just works with him. I found that trying to follow specific “tutorials” to try to learn the package didn’t really help, but several useful resources were helpful.

At work with us, this book began, but in fact it just went through flow objects, without falling into any real examples, Jamie Thomson blogs ( here and here ) are both excellent online resources, although they were really useful to me personally.

Answer 2

Try this book:

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

The best way to learn SSIS is to just do it. It is probably best to start and then turn to the book. Because the tool is so intense with the GUI, I usually got more after reading the book later, when I was already familiar with the environment.

Answer 3

, , . SQL CSV .

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

1 30 , SSIS 2008.

this can help get information about the specific properties of the suce file in accordance with our requirements.

thanks Pravdin