in

jetlounge

the minty fresh blog that whitens your teeth!

Customizable SSIS Data Flow Transformations

by David Leibowitz | December 17, 2007 | Comments: 0

Expression properties can be used to provide a great deal of flexibility in runtime changes to SQL Server Integration Services pacakges. Unfortunately, their usage in Data Flow Transformations is limited. The only Data Flow tasks in SSIS that can be modified using expression properties are:

Conditional Split
Derived Column

The only other option is to use the Script Transformation to basically do whatever you'd like. But that does not provide the most optimal performance.

del.ico.us digg this technorati BlinkList Furl reddit DotNetKicks google! live Facebook Stumble Upon Yahoo!




Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
Powered by Community Server (Non-Commercial Edition), by Telligent Systems