title: Bulk Insert into SQL Server with Python not working
body: <p>I'm attempting to bulk insert a csv into a table in SQL server. The catch is, the data doesn't match the columns of the destination table. The destination table has several audit columns that are not found in the source file. The solution I found for this is to insert into a view instead. The code is pretty simple:</p>
  
  <pre><code>from sqlalchemy import create_engine
  engine = create_engine('mssql+pyodbc://[DNS]')
  conn = engine.connect()
  sql = "BULK INSERT [table view] FROM '[source file path]' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')"
  conn.execute(sql)
  conn.close()
  </code></pre>
  
  <p>When I run the SQL statement inside of SSMS it works perfectly. When I try to execute it from inside a Python script, the script runs but no data winds up in the table. What am I missing?</p>
  
  <p>Update: It turns out bulk inserting into a normal table doesn't work either.</p>