John Rowan (11/10/2009)
Well, I always say I learn something new every day and today is no exception.The expression builder is not available from the flat-file destination properties window when working inside the data flow. I had no idea that you could set expressions on data flow tasks from the data flow properties at the control flow level.
I've done a great deal of SSIS work, but this one's new to me. Thanks for the insight John!
Thanks for the feedback, John R.
I learned this the hard way when I was trying to dynamically set the location of a XSD file on an XML Source (it had a GUI interface for the XML file which could be a variable, but not the XSD). After doing this in one of my packages, I also realized that many of the different properties within the different Data Flow tasks showed up under the Misc. section of the properties window of the Control Flow Task including the transformations I place in a Derived Column Task.
It definitely has been helpful find the various Data Flow tasks properties exposed for expressions on Control Flow.