Advertisement

Hello World—Your First SSIS 2012 Package

  • Francis Rodrigues
  • Michael Coles
  • David Dye

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.

Keywords

Visual Studio Source Component Flat File Connection Manager String Function 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Francis Rodrigues, Michael Coles, and David Dye 2012

Authors and Affiliations

  • Francis Rodrigues
  • Michael Coles
  • David Dye

There are no affiliations available

Personalised recommendations