Thanks, Mack. Actually I tried another non-script way, which contains couple of data conversions in data flow. ADONET Source -> Copy the column assigning a simple column name (For certain reason I could not use Derived column DFT to access [Measures].[WhateverTheMeasure]) -> Data Conversion (Convert To DT_WSTR) -> Data Conversion ->(Convert To DT_I4 or Whatever the finial variable type is) ->Recordset Destination (pick up the DT_I4 column and assign to a object variable), and then use foreach container to assign to your target variable. This method is a little trivial but easy to debug on the fly.