Script for assigning variables
Hi,
I have 3 columns that are in Derived Column transformation. I want to assign these values to respective 3 variables in packages. for this i have taken script component for transformation. could you please let me know how i can assign derived columns to variables
in the package.
February 26th, 2011 5:37am
You've duplicated post?
The first step is have the variables created in scope you need.
The second step in use a Script component to asign column values to variables:
Configure Script component, enter to editor and fill custom properties, ReadWriteVariables property. Here set your variables. After this push on Edit Script and go to Input0_ProcessInputRow and write this code:
variables.VariableForDate = Row.DateColumn;
variables.VariableForTotal = Row.TotalColumn;
variables.VariableForCounter= Row.CounterColumn;
and done!Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 5:56am