End Google Ads 201810 - BS.net 01 --> hi..
I m new to Oracle and c#.still I am tryiyng to picking up stones here

currently I am working on Script Task tool in SSIS (Using c#) in which I need to store the resultset from my Oracle stored procedure in to a MS access table.Below is the code:
public void Main() { OracleConnection conn = new OracleConnection(); // TODO: Add your code here conn.ConnectionString= "UserId=XXXX;Password=XXXX;Data Source= "XXXXXXX;"; conn.Open(); //execute stored procedure here DataTable resultDT = new DataTable(); OracleCommand Cmd = new OracleCommand(); Cmd.Connection = conn; Cmd.CommandText = "My_StoreProc"; Cmd.CommandType = CommandType.StoredProcedure; OracleParameter[] paramsArray = new OracleParameter[2]; paramsArray[0] = new OracleParameter("fromDate", OracleDbType.Date, ParameterDirection.Input); paramsArray[1] = new OracleParameter("toDate", OracleDbType.Date, ParameterDirection.Input);
..and here after I am stucked how to proceed with ..
how to use Oracle dataadapter,dataset and store this result set in an Access table?Any help will be appreciated!

Thanks in advance!

BigFish