Using SqlBulkCopy from datatable in .NET
Using copy As New SqlBulkCopy(Conn.Connection, SqlBulkCopyOptions.Default, Conn.Transaction)
copy.ColumnMappings.Add("Column2", "PMO_PartNo")
copy.ColumnMappings.Add("Column4", "PMO_Part_Name")
copy.ColumnMappings.Add("Column2", "PMO_PartNo")
copy.ColumnMappings.Add("Column4", "PMO_Part_Name")
copy.DestinationTableName = "PMS_MIG_Part_Master_Upload_Original"
copy.WriteToServer(dt1)
End Using
copy.WriteToServer(dt1)
End Using
No comments:
Post a Comment