public static void Load(string ilrPath, string schema, string srvr, string db, string security, bool createTables) { var loader = new SQLXMLBulkLoad4(); loader.ConnectionString = $"Provider=sqloledb;Server={srvr};Database={db};{security};"; loader.ErrorLogFile = "LoadErrors.xml"; loader.KeepIdentity = false; loader.SGDropTables = createTables; loader.SchemaGen = createTables; loader.Execute(schema, ilrPath); }
private void LoadXmlToTempDb() { var objBL = new SQLXMLBulkLoad4 { ConnectionString = temp_connStringPart, ErrorLogFile = "error.xml", SchemaGen = false, SGDropTables = false, }; foreach (var key in filesNamesMasks) { var schemePath = schemes[key]; var xmlPath = versionFiles[key]; objBL.Execute(schemePath, xmlPath); } }