SqlBulkCopy Alternative for Temporary Table on SQL Azure

When dealing with SQL Azure, SQLBulkCopy connection issues occur.

We are currently trying out the SQLBulkCopy API on the new SQL Azure CTP....While we have been able to consistently migrate tables with about a million rows, we are facing connection errors when working with larger tables. We keep getting (after random row transfers) the following error:...A transport-level error has occurred when receiving results...

Mapping columns in a DataTable to a SQL table with SqlBulkCopy

I would like to know how I can map columns in a database table to the datatable in c# before adding the data to the database....using (SqlBulkCopy s = new SqlBulkCopy(conn)) { s.DestinationTableName = destination; s.WriteToServer(Ads_api_ReportData); }

Insert Dictionary elements into SQL table as rows using IDatareader and SqlBulkCopy

I need to improve dramatically the execution time of a process wich currently is just like this:...private Dictionary<int, SingleElement> elements_buffer; // ... Create and load values into "elements_buffer" // (string, Datetime, double) string query = "INSERT INTO Tests.dbo.test_table " + "(element_name,element_init,element_width) VALUES"; ...

SqlBulkCopy to temporary table in SqlServer 2008

i need to move a large amount of data to a sql server 2008 database. I get data from a source server and write using SqlBulkCopy to destination server. this data have to be parsed from a stored procedure and then deleted. I'd like to create a temporary data but, if i create the temp data on the client using SqlCommand the SqlBulkCopy can access the...

How to use SqlBulkCopy with transaction on ReliableSqlConnection in sql azure

Our application on azure cloud service, We need to perform some operations on sql azure using the same transaction, (insert into and SqlBulkCopy) using ReliableSqlConnection to allow Transaction.Rollback If any steps fail ...but run this code: using (SqlBulkCopy ContactsDistBulkCopy = new SqlBulkCopy(oConnection, SqlBulkCopyOptions.KeepIdentit...

SqlBulkCopy ColumnMapping error CSV to DataTable to SQL Server Table

I am trying to bulk insert a CSV file into a SQL Server database....The process is ....CSV... file to ...DataTable... to ...SqlBulkCopy... to SQL Server....When I run this I get this error: ...The given ColumnMapping does not match up with any column in the source or destination...When I directly import the CSV into SQL Server via Management Studio...

SqlBulkCopy Wcf Rest Moving Data between 2 sql server tables

I am trying to move data from some tables from one sql server database to another sql server database. I am planning to write a wcf rest service to do that. I am also trying to implement this using SQLBulkCopy. I am trying to implement the below functionality on button click. Copy Table1 data from source sql server to Table 1 in destination sql ser...

Can I use sqlbulkcopy with Azure SQL Paas?

Can I use sqlbulkcopy with Azure SQL Paas?...I have an app that does bulk copy to a database and we are testing it with SQL PaaS. It appears to be failing on the SQLBulkCopy. ...I thought I read this is not supported somewhere but do not see it in the Azure SQL documentation. Is this still a limitation? Where is that documented?...I am using .net c...

SqlBulkCopy *VERY* slow on Azure Sql and C#

I am inserting records into sql using SqlBulkCopy and FastMember...Locally I can insert 100k records in about 2 seconds. When I run this on an Azure web app webjob and an Azure Sql Database it's taking more than 10 minutes and timing out the transaction. The table definition is the same, similar amounts of data in the table etc. There are no locks,...

Create procedure that will insert or update data from one temporary table to other 4 tables

I need to Create procedure that will ...insert or update data from the source table into the target1 table...Insert data into target2 table AND will get inserted ID from target1, target2 tables...Insert them into target table3...Insert target1.ID into target4 table...the source table is a temporary table, and I use bulk copy to insert big data into...