Integration Services for Dummies type book/resource?

Question

Integration Services for Dummies type book/resource?

pietlinden

SSC Guru

Points: 63503
More actions
November 5, 2014 at 3:34 pm

#148507

While I understand what SSIS does, I'm not terribly good at it. Is there a book that people recommend for learning it? I have Brian Knight's book on SSIS 2008 (Learn in 24 hours), which is okay, except either the videos are really blurry or my eyesight is failing quickly.
I guess what I'm looking for is almost an SSIS book written almost like Brian Larson's book on SSRS 2008.
Is SSIS pretty simple and I'm overthinking it?
Thanks!
Pieter

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

You can start here: Stairway to Integration Services[/url]. I like all the stairways but this one is particularly good.

I just finished reading:

Microsoft SQL Server 2012 Integration Services

which is good (not great).

I found the "Step by Step" books for BI topics (e.g. SSIS, SSAS) pretty good but I don't think they are making them anymore.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Ells SSCrazy Eights Points: 9901 More actions · Answer 2

Agree with Alan,

Stairways are excellent, Step by Step too.

But the best dummies style book

The 24 hour trainer shows you tasks etc in a brief quick way. Easy to consume

E

aarionsql SSCrazy Points: 2392 More actions · Answer 3

I would recommend 'Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services ' as a quick reference.

If you work through that even though it is written for 2008 you will learn alot about SSIS . It has 3 pages on each component/task with examples.

pietlinden SSC Guru Points: 63503 More actions · Answer 4

I have that book... the only thing I am not thrilled about is the quality of the videos. Going to see if it will work okay with SSIS 2012. Only one way to find out... go try it. And I have to learn it!

MMartin1 One Orange Chip Points: 27795 More actions · Answer 5

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is a good one overall.

----------------------------------------------------

Phil Parkin SSC Guru Points: 246962 More actions · Answer 6

MMartin1 (11/6/2014)
There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is a good one overall.

Wow, this one must be good: it's from the future! :hehe:

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

MMartin1 (11/6/2014)
There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is a good one overall.

There is an update for that book:

Professional Microsoft SQL Server 2012 Integration Services

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

MMartin1 One Orange Chip Points: 27795 More actions · Answer 8

Phil Parkin (11/7/2014)
MMartin1 (11/6/2014)
There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is a good one overall.
Wow, this one must be good: it's from the future! :hehe:

It is awesome ! 🙂 ...I'll blame it on the keyboard, didn't type what I told it with my fingers 😀

----------------------------------------------------

pietlinden SSC Guru Points: 63503 More actions · Answer 9

Anything new and exciting in the new version (like screen captures/video that you can actually read)? Shame, because the rest of the book looks pretty good.