Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Videos · SQL Programming Video Training
   
SQL Server Integration Services Training Videos
Integration Services Videos in Series Home  Subscriber Videos  

SSIS Package Configurations Stored in SQL Server (Video Series)

Video Image Video Category: Package Management - Security, Storage, Logging and Change Management

Skill Level: 200 (Beginner - Intermediate)

Versions/Editions Covered: SQL Server - All Versions
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.

Highlights from this series:

  • Basics of Package Configurations via Variables
    • Creating a package
    • Accessing the variable
  • Enabling and Adding configurations for your package
  • Working in the Package Configuration Wizard
    • Getting started
    • Specifying configuration settings
  • Choosing the appropriate database for your package configurations
    • Creating and working with a database specifically for utilities, such as package configurations
  • Defining Configurations table columns and finishing a Package Configuration
    • ConfigurationFilter
    • ConfiguredValue
    • PackagePath
    • ConfiguredValueType
  • Problems with using the ConfigurationFilter defaults
    • Table logic
    • How to effectively run commands
    • Specifying PackagePath correctly
  • Importing a text file via Package Configuration

 

 

Videos in this Series:



Other Websites We Offer
LearnExchange.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
10/6/2008 8:16:41 PM