Managing the SSIS Service

In this video, Brian discusses the role of the SSIS service and how it is configured. He also talks about how to create a central ETL server to handle all of your SSIS ETL.

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

Benjamin Lotter on 10/16/2008

Very helpful for our consolidation effort. I'm not sure why we needed to see the entry in the registry, though. It seems we could more easily search for the ini file.

Scott Stauffer on 1/16/2009

Way Cool Brian!

Vadis on 8/8/2010

not very clear on multi-server /multi-instance configuration management. specific example of managing a pkg from remote server would have been useful for me. Thanks

Jason Yousef on 3/14/2011

Great Tip!

Jon on 3/14/2011

Very informative, clear demonstration. Thank You!

Mark Cusano on 3/14/2011

Excellent!

Michal on 3/14/2011

You should point the audience to the resources where to find more information about the subject..

Antoon on 3/14/2011

Presenter needs to slow down his speach.

James Lim on 3/14/2011

I haven't setup a single SSIS instance with access to multiple server packages previously. Good info!

DP on 3/15/2011

Nice tip.

Ingrid on 3/15/2011

Excellent

glyn on 3/16/2011

Very Good.

Don Davis on 3/16/2011

Would like to see more on Centralized SSIS.

Frank on 3/22/2011

Simple and deep explanation. Directly to the point. Thank you

Maurice Ivory on 8/5/2011

Very Good presentation.