Monday, June 30, 2008

New SQL Server Integration Services Video Tutorial: Part 1 - What Are Package Configurations and How Do You Use Them?

Part 1 - What Are Package Configurations and How Do You Use Them? - view details
A common problem that many people encounter in DTS is moving packages between their development, test, and production environments. In DTS this would require a handful of edits to make sure the connection objects were pointing to the correct servers. Integration Services, SSIS, has fortunately provided us with a solution to this problem - package configurations! Package configurations allow your package to be dynamically updated at run-time, thus saving you time by eliminating those pesky manual edits.

In this video series, we will talk more about package configurations in SSIS and see a little bit more of storing the package configurations inside SQL Server. We will also go over some best practices as well as take our demos beyond what the defaults are. In this first video in the series, Scott will go over the concept of package configurations and demonstrate to you how to use them

Highlights from this video:

  • Basics of Package Configurations via Variables
    • Creating a package
    • Accessing the variable
  • Working with SQL Server 2008 and SQL Server 2005
  • Enabling and Adding configurations for your package
  • Working in the Package Configuration Wizard
    • Getting started
    • Specifying configuration settings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: package, package configuration, configure, variable, dts, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 1:21 PM