h1

Variable Expressions With BIxPress

September 14, 2011

The expression language in SSIS is a powerful but sometimes frustrating tool.  At times it resembles T-SQL at other times some of your typical programming languages which can make implementing them in SSIS packages a daunting task.   There are plenty of samples out on the web spread across blogs and forums, however, BIxPress actually has a library full of some of the most commonly used SSIS expressions already built in. The Expression Manager organizes all your common SSIS expressions for use anywhere you can use SSIS expressions, such as variables and data flow pipelines.  I have found this most useful when trying to build variable expressions.  To launch the Expression Manager when working with variables select Expression Library Icon from the Variable Toolbar Extension

image.

Now that the Expression Manager window is open you should see two tabs across the top.  In the My Expressions tab you add your own expressions to the library which you will then have access to without having to open up another document where you might have stored it, or another package where you might have used the expression before.

image

In the Standard Expressions Tab there are a ton of pre built expressions covering date expressions, string manipulation expressions and file/folder expressions among others.

image

The Expression Manager has saved me a ton of time by not having to search and search for the right syntax.  If you get a chance to try out BIxPress you won’t regret it.

Advertisements

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

%d bloggers like this: