New SQL Server Integration Services Video Tutorial: Variables in SSIS

Variables in SSIS - view details

Of course you can use variables in SSIS - was it really ever a question? SSIS variables are far more robust, typed, and extensible in SSIS than they ever were in DTS. You can create multiple namespaces, have variables with the same names (crazy, eh?), and work with scoped variables.

Highlights from this video:

• How namespaces work in SSIS variables
  
• Modifying variable values
  
• Using Expressions for variable values
  
• An overview of the datatypes used by variables
  
• System variables and User variables

and much more

---

• Source: http://www.LearnIntegrationServices.com/
• Category: Variables and Expressions - Creating Dynamic SSIS Packages
• Skill Level: 300 (Intermediate)
• Length: 17:04 (17.2MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

---

Keywords Associated with this video: global variables, variable assignment, set value, system.object, system.string, int32, int64, int16, uint16, uint32, uint64, cha