MSBI # 12 – SSIS # 5–Familiar with SSIS Variables from 0 to Expert (Part–III– Overview)

Continuing from my last post on variable basics ,you can click here to view MSBI # 10 – SSIS # 3–Familiar with SSIS Variables from 0 to Expert (Part–I-Introduction) « (B)usiness (I)ntelligence Mentalist

And then on for System Variable MSBI # 11 – SSIS # 4–Familiar with SSIS Variables from 0 to Expert (Part–II – System Variable) « (B)usiness (I)ntelligence Mentalist

Where SSIS Variables are used

  • Variables Usage Scenarios
  • Property Expressions
  • Data Flow Expressions
  • Precedence Constraint Expressions
  • Parameters and Return Codes
  • For Loop Expressions
  • Parent Package Variable Configurations
  • Script Task and Script Component
  • For more Details on above usage Click Here

How to: Set the Properties of a Variable

  • The Variables window.

  • The Properties window. The Properties window lists properties for configuring variables that are not available in the Variables window: Description, EvaluateAsExpression, Expression, ReadOnly, and ValueType.

  • For more Details on above usage Click Here

Converting SSIS Data Types to .Net Data Types

If you use Scripting tasks, the CLR or build components for SSIS, you will need to convert values from their SSIS types into .Net types. Here’s a quick list of the SSIS data types and their .Net companion.

image

For more Details on SSIS variable you can visit following link

http://www.techrepublic.com/blog/datacenter/using-user-defined-variables-in-sql-server-2005-integration-services-packages/237

Using System Variables as Parameters in an OLE DB Source Query

SSIS Package – User Variables – Robert Robbins 

If you wan more interesting link please visit our link resource website

One thought on “MSBI # 12 – SSIS # 5–Familiar with SSIS Variables from 0 to Expert (Part–III– Overview)

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: