CREATE TABLE [dbo].[TABLE1](
	[FIELD1] [varchar]( 30 ) NOT NULL,
	[FIELD2] [varchar]( 30 ) NOT NULL,
	[FIELD3] [datetime] NOT NULL,
	[FIELD4] [real] NULL,
	[FIELD5] [real] NULL,
	[FIELD6] [datetime] NULL
)

CREATE TABLE [dbo].[TABLE2](
	[FIELD1] [varchar]( 30 ) NOT NULL,
	[FIELD2] [varchar]( 30 ) NOT NULL,
	[FIELD3] [datetime] NOT NULL,
	[FIELD4] [decimal]( 38 ,  6 ) NULL,
	[FIELD5] [decimal]( 38 ,  6 ) NULL,
	[FIELD6] [datetime] NULL
)

SqlDataReader reader = new SqlCommand("SELECT * FROM Table1").ExecuteReader();
SqlBulkCopy copy = new SqlBulkCopy(destConnect);
copy.WriteToServer(reader);