title: "IDENTITY_INSERT is set to off" sqoop error while exporting table to Sql Server
body: <p>I am exporting a simple hive table to Sql server. Both tables have the exact schema. There is an identity column in Sql Server and I have done a "set identity_insert table_name on" on it.</p>
  
  <p>But when I export from sqoop to sql server, sqoop gives me an error saying that "IDENTITY_INSERT is set to off". </p>
  
  <p>If I export to a Sql Server table having no identity column then all works fine. </p>
  
  <p>Any idea about this? Anyone faced this issue while exporting from sqoop to sql server?</p>
  
  <p>Thanks</p>