May be there is a better way, but you can generating a datatable from source and load it to destination if the process is successful, execute the drop table query.

SELECT * INTO newTable FROM oldTable.

This will copy the table structure and data in it

If you require the structure of the table one[i.e. no data] then

SELECT * INTO newTable FROM oldTable WHERE 0 = 1

Use SQLBulkCopy to do bulk data transfer from one table to another. SQLBulkCopy object is specially developed for such purposes.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

u can copy the table in to another table using "into" and then execute the "drop" command

By using SqlBulkCopy. use WriteToServer() method to write to desto table.
*** but make sure that table with same schema that of src is created*** else its throws excepton

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question