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. |
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 5:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics