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

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

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 Server 2005 allows you to bulk copy data from a small table to a bigger table.

For starters : one of the things I've learned over the years is that MSSQL does a great job at optimizing all kinds of operations but to do so heavily relies on the statistics for all tables involved. Hence, I would suggest to run "UPDATE STATISTICS processed_logs" & "UPDATE STATISTICS unprocessed_logs" before running the actual inserts; even on a ...

SQL Bulk Copy to SQL Server with Data Modifications in Excel

You probably want a DataReader or DataSet that you can iterate over for validation/modification before importing....This utility might help you - ...http://exceldatareader.codeplex.com/

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

Splitting a huge table into two and bulk copying using SQL Server and C#.net

I would create it in one table and create well defined indexes. ...Consider a filter index for the flag column. This is done with a where clause in t-sql and the filter page in ssms. ...http://msdn.microsoft.com/en-us/library/cc280372.aspx

In SQL Server 2005, how can I bulk transfer comparable data to two tables?

It's not quite clear what ...exactly... and how exactly you're trying to store the data from your Excel import into these two tables, and where that ...groupID... comes from.......Basically - you're right - you cannot bulk insert into multiple tables. So my take would be:...1) Do the bulk insert from Excel into a ...Staging... table as today...2) T...

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

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

Bulk copy (C API) and ODBC driver for SQL Server

Found it. It's possible when installing the driver to install also the SDK. It will be in C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\XX-version-XX