Abstract
In the previous chapter, we introduced you to SQL Server 11’s development tools, BIDS and SSMS. Before we start discussing the in-depth details, we will walk you through some example packages to demonstrate the capabilities of this powerful toolset. As a developer, it is much easier for you to gain an understanding after you’ve tried out the tools for yourself. This chapter teaches you how to start with the simplest package, consisting of a Data Flow task that will have only a source and a destination. After walking you through creating the easy package, we will guide you through a more complex, real-life example of a package. This package’s goal will be to emulate some of the potential requirements that may become a part of your ETL process, and as such is a relatively complex example to be introduced in the third chapter.
Take the first step in faith. You don’t have to see the whole staircase, just take the first step.—Civil Rights Movement leader Martin Luther King Jr.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Francis Rodrigues, Michael Coles, and David Dye
About this chapter
Cite this chapter
Rodrigues, F., Coles, M., Dye, D. (2012). Hello World—Your First SSIS 2012 Package. In: Pro SQL Server 2012 Integration Services. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3693-1_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3693-1_3
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3692-4
Online ISBN: 978-1-4302-3693-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books