Modifying records on import in Data Flow with Script?

[elhaix]

Hi Gang,

During an Excel import Data Flow, I'd like to change the value of an incoming column for each row.

To do so, I'd like to run it through a script task which performs some functions and spits out the new cell value.

What would be the process for this?

I know I can do it in the control flow, after all the data has been loaded by creating a SQL Task to grab rows then run a Script Task, but this would be after the data is already imported. I'd rather do it during the import.


Thanks.

 

[MDXer]

What exactly do you want to do to the cell as there may be better ways to accomplish it than a script task.

 

[elhaix]

I'm running the value through an encryption algo.

 

[williey]

why not use derived column?

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.