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
مواقع النشر (المفضلة)