Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Re-use Derived Column

Author  Topic 

LearningSQLKid
Yak Posting Veteran

51 Posts

Posted - 2011-09-08 : 00:48:55
Hi Guys

I'm designing an SSIS package which has a configuration file.
This file contains a variable. I want to use the value of variable
as derived Column.
I know how to work with derived column but i want to declare/create the transformation only one time in the data flow and then re-use it with multiple ole db source because throughout the package the value will be same.

Is that possible, any suggestion ?

Thanks


Select Knowledge from LearningProcess
   

- Advertisement -