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

Create a free account · Sign In

Integration Services Video Tutorial	Home Subscriber Videos

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

Chapter: Package Management - Security, Storage, Logging and Change Management

Skill Level: 200 (Beginner - Intermediate)
Duration: 9:00
Size: 10.0MB
Versions/Editions Covered: SQL Server - All Versions
Added/Updated: Jun 30, 2008

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

Tags for this video: beginner beginning configure DTS for dummies introduction package package configuration step by step variable

< Back

People Who Downloaded this Video Also Downloaded:

Title	Skill	Download
Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS	300	Download
Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio	100	Download
Pt. 1 - An Overview of Using SSIS for Newbies and Beginners	100	Download
Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS	100	Download
Pt. 2 - Creating Your First SSIS Packages (Integration Services Packages)	200	Download

This video is part of the following video series: "SSIS Package Configurations Stored in SQL Server"

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

To view all videos in this series, click here

About the Instructor:

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

About Us

· Corporate Philosophy
· Advertise With Us
· Become an Author
· Contact Us

Video Playback

· System Requirements
· TSCC Codec (to play videos)
· Troubleshooting/Problems

Subscriptions

· Pricing/Buy Now
· Testimonials
· Privacy
· Terms of Service