Hi all, I discovered that there is problem between Oracle Number format and SSIS Number format. So, I tried another way: 1. select a result set having numeric data column and put the result set into an Object type variable in SSIS 2. use foreach loop container and put an "Execute SQL Task" component inside the container 3. in the "Execute SQL Task" component, I execute an Oracle procedure: begin update_procedure(?) ; end; --------------------------------------------- Oracle procedure is as follows: create or replace update_procedure(p_readingStr string) is p_reading numeric; begin p_reading := cast( p_readingStr as NUMBER); end update_procedure ; 4. In Variables tab, I define a String variable "reading". Also, in parameter mapping of the "Execute SQL Task" component, i use datatype varchar for User::reading The result is when executing p_reading := cast( p_readingStr as NUMBER); it shows an error "ORA-06502: PL/SQL: numeric or value error: character to numeric conversion error" Is there any method to solve the problem? Thanks! (Version: SQL Server 2005 SP3, Oracle 10g)

Solution: Use script component to generate the script for executing Oracle stored procedure. Save the script in variable and then execute the variable.