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

 

 

About the Instructor: