connectionString = GetDatabaseConnectionPath(); ds.ReadXml(@"..\..\XML\edition_report20140822.xml"); sourceData = ds.Tables[0];
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection, SqlBulkCopyOptions.Default, transaction)) { // bulkCopy.ColumnMappings.Clear(); //column mappings //bulkCopy.ColumnMappings.Add("edition_eanisbn13", "szISBN"); //bulkCopy.ColumnMappings.Add("temp_edition_format", "szFormat"); //bulkCopy.ColumnMappings.Add("temp_binding_short_name", "szFormatAbbreviation"); //bulkCopy.ColumnMappings.Add("edition_product_type", "szMedia"); //bulkCopy.ColumnMappings.Add("producttype", "szMediaAbbreviation"); //bulkCopy.ColumnMappings.Add("edition_publication_date", "dtPublicationDate"); //bulkCopy.ColumnMappings.Add("work_cover_title", "szTitlePrefixAndTitle"); //bulkCopy.ColumnMappings.Add("work_sort_title", "szTitleAndTitlePrefix"); //bulkCopy.ColumnMappings.Add("work_sub_title", "szSubTitle"); //bulkCopy.ColumnMappings.Add("edition_product_type", "szPrimaryEditionEAN13"); //bulkCopy.ColumnMappings.Add("group_titles_series", "szSeries"); //bulkCopy.ColumnMappings.Add("group_sequence_number_series", "szVolume");
bulkCopy.DestinationTableName = "tblTitle"; bulkCopy.WriteToServer(copyDataTable);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)