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							* SQL Server DBA Videos * SQL Programming Video Training * More Videobooks...	Search My Account More Videobooks Sign in
Home FREE Video Tutorials Subscriber Video Tutorials Subscriptions FAQs Our Other Sites About Us

Home
- Free Videos
- Subscriber Videos
- Buy Now (Subscriptions)
- More Video Websites
- Search for Videos
- Tag Cloud

Subscriptions
- Subscribe!
- Testimonials
- List of Videobooks

Quick Links
- About the Author
- Login
- FAQs

Site Map

Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)

Pt. 1- Introduction to SQL Server 2005's Integration Services

Pt. 3 - Using Proxies and Credentials When Scheduling Your SSIS P...

Pt. 1 - What Are Package Configurations and How Can I Use Them?

Formatting Options in SSIS - How to Make Your Packages More Manag...

Integration Services Video Tutorial	Home Subscriber Videos

Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS - Training Video
Category: Variables and Expressions - Creating Dynamic SSIS Packages

Skill Level: 300 (Intermediate)
Duration: 15:34
Size: 14.2MB
Versions/Editions Covered: SQL Server 2005
Added/Updated: Dec 18, 2006

Expressions are new in SSIS (meaning that they were not in DTS) but they allow you to create extremely flexible packages. Expressions can be used to assign values to variables, help you determine whether to execute a task, and to assign properties. If you ever found yourself writing ActiveX code (VBScript) in DTS to determine which task to execute based on a variable's value, then you probably can forego the scripting all together in favor of expressions! They are very powerful in SSIS and you'll want to have a solid understanding of how to write them and how to use them.

Highlights from this video:

When should you use expressions?
What language is the expression syntax written in?
Accessing variables from expressions (using the long way and the short way)
How to use expressions with the For Loop container in the InitExpression, EvalExpression and the AssignExpression
Locating and using the Expression Builder
An overview of writing expressions

and much more

Tags for this video: code coding java syntax transact-sql TSQL writing expressions

< Back

People Who Downloaded this Video Also Downloaded:

Title	Skill	Download
Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio	100	Download
Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS	100	Download
Pt. 1 - An Overview of Using SSIS for Newbies and Beginners	100	Download
Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS	100	Download
Pt. 2 - Expressions - Using Expressions In SSIS Tasks	400	Download

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)

Company News

» We're also sponsoring the St Louis SQL Server User Group July 9

» We're sponsoring the Billings, Montana .NET User Group July 8

» We're sponsoring the San Antonio, TX Alamo Coders User Group June 10th

» Scott had a baby!


Home \| About Us \| Advertising \| Become an Author \| Contact Us \| Privacy \| System Req's \| Terms \| Testimonials \| Work for Us! \| \| Site Map
© 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.

8/7/2008 2:52:59 PM