title: SSIS 2012 C# script task data source - No data for Rows
body: <p>i am having an issue when trying to use a c# script task as a data source for a data flow task in SSIS 2012. I have a much larger query I am going to run, but for now I just wanted to prove out that this would work, but so far it won't. Below is the code, and is only returning one field, however once it gets to the line which is last name = reader.getstring(), it throws an exception saying no data for the row/column is available. I know for a fact the query is returning 10 rows, not sure what is going on. I wrote the code following this link: <a href="https://msdn.microsoft.com/en-us/library/ms136060.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms136060.aspx</a> </p>
  
  <p>Any advice?</p>
  
  <pre><code>using System;
  using System.Data;
  using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
  using Microsoft.SqlServer.Dts.Runtime.Wrapper;
  using System.Data.OleDb;
  
  
  [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]
  public class ScriptMain : UserComponent
  {
  
  OleDbDataReader reader;
  OleDbConnection myConnection;
  OleDbCommand myCommand;
  
  public override void PreExecute()
  {
      base.PreExecute();
  
  
      string sConnectionString = "Provider=MSDAORA.1;User ID = USER;Password=PASS;Data Source=SERVER;persist security info = false";
    //  string oracleQuery = Variables.OracleSQL;
  
      string oracleQuery = "select Name from Name_Table where rownum &lt; 10";
  
      myConnection = new OleDbConnection(sConnectionString);
      myCommand = new OleDbCommand(oracleQuery, myConnection);
  
      myConnection.Open();
  
      reader = myCommand.ExecuteReader();
  
  }
  
  /// &lt;summary&gt;
  /// This method is called after all the rows have passed through this component.
  ///
  /// You can delete this method if you don't need to do anything here.
  /// &lt;/summary&gt;
  public override void PostExecute()
  {
      base.PostExecute();
  
      reader.Close();
      /*
       * Add your code here
       */
  }
  
  public override void CreateNewOutputRows()
  {
     Output0Buffer.AddRow();
     Output0Buffer.Name = reader.GetString(0);
  
  }
  </code></pre>
  
  <p>}</p>