Using BCP, you may write from a SQL Server table to a file.

To Insert/Update in Main Table from Staging Table in SQL Server 2008

I would probably do something like this:...make your transformations on that staging table (add additional columns as needed etc.)...do the INSERT/UPDATE into the actual data table using the ...SQL Server 2008 ...MERGE... command... which is ideally suited for just this - update some existing rows, insert some new rows (and possibly delete some old...

Using sqlbulkcopy in C# asp.net to write xml data to a SQL server

You need some way to get your XML data into the DataSet before you can call .Tables[0]. Try using the ....ReadXml()... function of the DataSet class to load the data into your dataset:...FROM: ...http://msdn.microsoft.com/en-us/library/fx29c3yd(v=VS.100).aspx...DataSet dataSet = new DataSet(); DataTable dataTable = new DataTable("table1"); dataTabl...

Getting an exception writing a boolean to sql using a datatable and SqlBulkCopy

Encountered the same issue: setting bool column to true/false was ignored by bulk copy, all values were set to null. The previous answer helped to resolve it, but I had to add mappings for all columns to make it work:...foreach (DataColumn column in table.Columns) { sqlBulk.ColumnMappings.Add(column.ColumnName, column.ColumnName); } sqlBulk.Wri...

Excel Data to new SQL Server table using C# - new table not being created?

Hi think you are not checking your table name before inserting excel data into data table. you can go through the below code....class excelTwosheetsBulk1 { private static readonly log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); static void Main(string[] args) { log...

Update SQL server table using Datatbale

EDITED: Misread the original question. Here's the "bulk update":...UPDATE <table> SET tbl.value = dt.value FROM @Datatable dt INNER JOIN <table> tbl ON tbl.<id_column> = dt.<id_column>

Best method for importing data from text file into MS SQL Server

This includes a method that may be a more efficient way of reading your text file.... Sub readFixWidthTextFileIntoSqlTable() Dim sqlConn As New SqlConnection("Connection String Goes Here") sqlConn.Open() Dim sqlComm As New SqlCommand sqlComm.Connection = sqlConn sqlComm.CommandType = CommandType.Text sqlComm.CommandText ...

Missing Data after insert into my end sql table using Sql Bulk Copy

you need to look at the data in Access, and find/fix those bad column values, or handle them in your TSQL after the export. One option to debug - replace temp table with real table, replace datetime datatype with string, do your export, then query the table to find the bad values so you know what kind of data to look for. After that, you can swit...

Skip host file column in bcp format file Sybase

The issue you have is that there is no terminator character on the columns you want to omit, please check the following image (...I got it from ...here...):...Basically, if you want to omit a column coming in the source file, just:...Use as Server Column Order = 0...The terminator has to be specified!...The length of the source file is also importa...

Microsoft SQL BCP Format File - Version?

I managed to solve this problem by installing Microsoft® Command Line Utilities 11 for SQL Server® and adding the bcp.exe location to the path variables. Now I can export version 11 using bcp 11, thus making the exported format files compatible with SQL 2012. You can download it from here ...https://www.microsoft.com/en-us/download/details.aspx?i...

Unable to insert null values in SQL Table using SQL bulk

I guess the issue is that you are trying to convert a null value to a string and then try to put it in a field that only accepts datetime. Check if there is anything (so notnull) before converting it to string.