O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 50. Why automate tasks with SSIS?

Ted Krueger

SQL Server Integration Services (SSIS) is a platform that offers many benefits when Windows Server and SQL Server are the primary technologies used. For cost reasons, SSIS is a good choice when SQL Server is already implemented. This is because a license is required only if SSIS is installed on a server other than one that has a fully licensed SQL Server Engine installed. SSIS integrates directly with SQL Server, and the integrated development environment (IDE) of Visual Studio .NET is used to develop SSIS packages. This can be valuable when Visual Studio .NET is already being used in house for other Microsoft-based development by limiting learning curves of the IDEs. By default, SQL Server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required