/// <summary>
        /// Imports a redirect file into the Skybrud redirect table
        /// </summary>
        /// <param name="file"></param>
        /// <returns></returns>
        public virtual ImporterResponse Import(IRedirectsFile file)
        {
            var response = new ImporterResponse();

            file.Load();

            response.ImportedItems = file.ValidatedItems;
            response.File          = file;

            var inserter = new SqlServerBulkCopy();

            inserter.BulkImport(file.ValidatedItems);

            RaiseEvent(response);

            return(response);
        }