Tag Archives | SSIS

SSIS Expression Language and Dynamic Property Expressions

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and Dynamic Property Expressions. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004). Build […]

Continue Reading 0

SSIS Expression Language and the Conditional Split Transformation

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and the Conditional Split Transformation. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004). […]

Continue Reading 0

SSIS Expression Language and the Derived Column Transformation

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. The SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax. In this series, I provide examples that demonstrate common uses for the SSIS Expression Language. […]

Continue Reading 0

SSIS Expression Language and Variables

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and Variables. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004). Build The Demo Project […]

Continue Reading 0