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
The SQL Server Integration Services, SSIS, is a powerful ETL tool. Although it is the most powerful tool, you can quickly learn SSIS tutorials in 28 days (Maximum). Remember, it is the second-largest tool for performing Extraction, Transformation, and Load (ETL process) operations.
SSIS is one of the easiest and powerful ETL tools to be worked with and also supports various file formats.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With