var vocabularyLookupTable = new DataTable();
            vocabularyLookupTable.Columns.AddRange(
                new[]
                {
                    new DataColumn("VocabularyLookupKey", typeof(Guid)),
                    new DataColumn("CustomerSystemName", typeof(string)),
                    new DataColumn("CustomerTableName", typeof(string)),
                    new DataColumn("CustomerColumnName", typeof(string)),
                });
            var vocabularyLookupRow = vocabularyLookupTable.NewRow();
            vocabularyLookupRow["VocabularyLookupKey"] = key;
            vocabularyLookupRow["CustomerSystemName"] = "MIHMS";
            vocabularyLookupRow["CustomerTableName"] = "PUB_CLM_claimpharm";
            vocabularyLookupRow["CustomerColumnName"] = "ndckey";
            vocabularyLookupTable.Rows.Add(vocabularyLookupRow); 

var connectionBuilder = new SqlConnectionStringBuilder
            {
                DataSource = ".",
                InitialCatalog = "DatabaseName",
                IntegratedSecurity = true,
                Encrypt = false,
                TrustServerCertificate = true,
                ConnectTimeout = 100000,
            };
            var sqlConnection = new SqlConnection(connectionBuilder.ToString());
            sqlConnection.Open();
            var transaction = sqlConnection.BeginTransaction();

            var bulkInsertVocabularyLookup = new SqlBulkCopy(
                sqlConnection,
                SqlBulkCopyOptions.Default,
                transaction)
            {
                DestinationTableName = "[InterfaceModule].[VocabularyLookup]",
                BulkCopyTimeout = 100000,
            };
            bulkInsertVocabularyLookup.WriteToServer(vocabularyLookupTable);
            transaction.Commit();