How to import from CSV to Sql when column is identity

Hello MEghana,

You can refer this one which will help you out,

https://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-csv-file-records-into-sql-server-database-using-as/

You can use SqlBulkCopy object to copy data from the CSV file to the database table.

string csvPath = @"C:\YourCsvFile.csv";
string tableName = "YourTableName";
string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

// Create a DataTable to hold the CSV data.
DataTable csvData = new DataTable();
using (OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM [" + tableName + "]", @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + csvPath + ";Extended Properties='Text;HDR=YES;FMT=Delimited'"))
{
    adapter.Fill(csvData);
}

// Use a SqlBulkCopy object to copy the data from the DataTable to the database table.
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
{
    bulkCopy.DestinationTableName = tableName;
    bulkCopy.WriteToServer(csvData);
}
connection.Close();

not using import wizard ,using C# console application

If you are using import wizard then you need to enable insert identity,

https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/