SqlBulkCopy Tutorial - Knowledge Base (KB)

Error inserting data using SqlBulkCopy

I'm trying to batch insert data into SQL 2008 using ...SqlBulkCopy.......Here is my table:...IF OBJECT_ID(N'statement', N'U') IS NOT NULL DROP TABLE [statement] GO CREATE TABLE [statement]( [ID] INT IDENTITY(1, 1) NOT NULL, [date] DATE NOT NULL DEFAUL...

SQLBulkCopy and Dates (1/1/1753)

I've got an application which has been working fine for quite a while, but there is an annoying item that continues to get in the way on occasion. ...Let's say that I use an object such as OracleDataReader or MySQLDataReader to pass the data to the sqlbul...

Using the SQL bulk copy in C# and deleting the string headers

The code below is what I use for inserting the data stored in txt file to sql:... public void extract_data() { openFileDialog1.ShowDialog(); DataTable dt = new DataTable(); StreamReader sr = new StreamReader(openFileDialog1.Fil...

sqlbulkcopy - When converting string to DateTime

I am using this code to insert a csv file to my database:... private void InsertDataIntoSQLServerUsingSQLBulkCopy(DataTable csvFileData) { using (SqlConnection dbConnection = new SqlConnection(ConnectionString)) { dbConn...

insert data using WriteToServer method datetime column gives exception

I am trying to insert a ...DateTime... into a column who data type is datetime. The value is assigned using ...DateTime.Now..., so I know that there isn't an issue with incorrect types in the code....The exception I get is:...The given value of type Strin...

Date Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM OverFlow error SqlBulkCopy

I am reading data from an access db and storing it in a temporary sql table then truncate the main sql table and insert the fresh data set and i am accomplishing that task using the code below but the datetime is giving me issues:...Console.WriteLine("Net...

SQL Bulkcopy coverting data type

In my .Net project I am loading in a CSV file so I can take that data, do some stuff with it, and fire out the results into an excel file. ...I'm handling this through a data table inside my code. In my results file, I have added a new column which I call...

Powershell inserting DataTable with SqlBulkCopy, that hold datetime columns

I'm trying to insert a predefined ...DataTable... into a SQL Server database, using ...Data.SqlClient.SqlBulkCopy.......There are different datatypes in the ...DataTable..., but the problem is with ...Datetime... columns....Like this one:...$Datatable.Col...

CSV to SQL - Add 1 day to a Date in a datacolumn

I am trying to add 1 day to all dates that are in a certain datacolumn ['RecordAddedDate']...csvData.Columns.AddRange(new DataColumn[3] { new DataColumn("Manufacturer", typeof(string)), new DataColumn("SupplierCode", typeof(string)), ...