Monday, June 30, 2008

New SQL Server Integration Services Video Tutorial: Part 2 - Using SQL Server Package Configurations in SSIS

Part 2 - Using SQL Server Package Configurations in SSIS - view details
This second video in the series will continue where the first video left off by further discussing and demonstrating the use of SQL Server Package Configurations. By the end of this video, you will have successfully created a new Package Configuration.

Highlights from this video:
  • Choosing the appropriate database for your package configurations
    • Creating and working with a database specifically for utilities, such as package configurations
  • Walking through the Package Configuration Wizard
    • Connecting to a database
    • Creating a table
    • Selecting properties to export (objects that will be changed at run-time)
  • Defining Configurations table columns and finishing a Package Configuration
    • ConfigurationFilter
    • ConfiguredValue
    • PackagePath
    • ConfiguredValueType
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, configure, package configuration, ssis, wizard, sql,