title: How to configure logstash to transfer data from MS-SQL server to elasticsearch
body: <p>I am trying to copy my table data from MSSQL server to elasticsearch, after going through some documents i wrote my config file for logstash, when i run the file from command prompt , i get this message :  </p>
  
  <blockquote>
    <p>"J_3a_.ELK.logstash_minus_6_dot_6_dot_2.logstash_minus_core.lib.logstash.pipeline.block
    in start_input"
    <a href="https://i.stack.imgur.com/bcX0M.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bcX0M.png" alt="screenshot from the command line"></a>
    I have the MSSQL database in aws-RDS.</p>
  </blockquote>
  
  <p>This is my conf file</p>
  
  <pre><code>input {
      jdbc {
          jdbc_driver_class =&gt; "com.microsoft.sqlserver.jdbc.SQLServerDriver"
          jdbc_driver_library =&gt; "J:\Java\sqljdbc_4.2\enu\jre8\sqljdbc42.jar"
          jdbc_connection_string =&gt; 
         "jdbc:sqlserver://skunestdevdb.czdnys4mper2.ap-southeast- 
           2.rds.amazonaws.com;database=skudevusr;user= 
         &lt;my_username&gt;;password=&lt;my_password&gt;"
          jdbc_user =&gt; "&lt;my_username&gt;"
          jdbc_password =&gt; "&lt;myPassword&gt;#"
          statement =&gt; "select * from product"
      }
  }
  output{
      elasticsearch{
        hosts =&gt; ["localhost:9200"]
        index =&gt; ["skunest_qa"]
      }
  }
  </code></pre>
  
  <p>I cant seem to get what is wrong here, i have provided necessary details in the conf file, the command line stucks showing above message. I have tried removing the username and password from the connection string.
  Help!!</p>