Bulk copy export in SQL using queryout

How to use SQL bulk copy to retrieve the IDs of added data records

I'm currently doing something like this:...DataTable objects = new DataTable(); DataColumn keyColumn = new DataColumn("name", typeof(string)); DataColumn versionColumn = new DataColumn("version", typeof(int)); versionColumn.DefaultValue = iVersionID; objects.Columns.Add(keyColumn); objects.Columns.Add(versionColumn); foreach (KeyValuePair<string,...

Is it possible to transfer data across servers using sql bulk copy?

Yes. In fact, in the demo code shown ...here..., they copy to a table within the same database.

In.Net, how can I bulk transfer sql (export) tables to csv or tsv files?

Are there any .Net libraries that provide a way of exporting sql database data to plain text files (i.e. csv\tsv)? SqlBulkCopy only applies to the import part of the solution and I prefer not to be calling any Process.Start calls to open up command prompts to call bcp.exe.

ASP.Net to MS-Access 2007 conversion (Bulk Insert, Bulk Copy)

Access 2007 will directly import XML. You can create an XSD for your particular data, then import that to create the table definitions. The XML should cleanly import from there.

SQL Bulk Copy to SQL Server with Data Modifications in Excel

I am reading up on ...SQLBulkCopy... and would like to use it to import thousands of rows from an Excel document to SQL Server. I keep reading articles that do it directly without modifying the data. I need to do some modifications and validations on the data in the Excel document before doing the ...SQLBulkCopy.... Is it possible to do this? I ...

Using file stream, sql bulk copy will not upload data to the database.

Simplify your code; there are plenty of ways to get the csv into a datatable - see ...How to read a CSV file into a .NET Datatable... for example. In your example above, you do not appear to be closing the stream after you have finished reading it... add sr.Close() before the return, or better still wrap the declaration in a using() statement:... ...

Access double to SQL decimal using SQL Bulk Copy

Your problem is that floating-point types like ...Double... often cannot store numbers ...exactly..., even values which seem to be quite "simple" numbers to us humans. This can be demonstrated by typing the following into the Immediate Window of the VBA editor in Access:...?(CDbl(81.60) * CDbl(100)) - CDbl(8160) ...The result returned is...-5.6843...

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.FileName); string input; dt.Columns.Add(new DataColumn("Counter", typeof(string)))...

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...

Using SQL Bulk Copy to insert ~3.7 million rows throws OutOfMemory exception

Thank you all for your response....I figured out what was the problem. Firstly, it didn't occur when calling the SQL Bulk Copy, which I assumed it could have been because, in previous run, I was able to run few 1000 less records than the current one, so I thought the SQL Bulk Copy had limitations or need to settings in order to handle large number ...