Free SQL Server Integration Services Video Tutorial: Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS

Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS - download

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

---

• Source: http://www.LearnIntegrationServices.com/
• Category: SQL Server Videobooks
• Skill Level: 300 (Intermediate)
• Length: 15:34 (14.2MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correc t security code.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: syntax, tsql, transact-sql, c#, c, java, code, coding, writing expressions