CREATE TABLE [exclu].[oig_leie](
	[LASTNAME] [varchar](20),
	[FIRSTNAME] [varchar](15),
	[MIDNAME] [varchar](15),
	[BUSNAME] [varchar](30),
	[GENERAL] [varchar](20),
	[SPECIALTY] [varchar](20),
	[UPIN] [varchar](6),
	[NPI] [varchar](10),
	[DOB] [date],
	[ADDRESS] [varchar](30),
	[CITY] [varchar](20),
	[STATE] [varchar](2),
	[ZIP] [varchar](5),
	[EXCLTYPE] [varchar](9),
	[EXCLDATE] [date],
	[REINDATE] [varchar](8),
	[WAIVERDATE] [varchar](8),
	[WVRSTATE] [varchar](2)
)

Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: Unable to retrieve data from the source.
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeBatchData(SQLServerBulkCopy.java:3626)
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.doInsertBulk(SQLServerBulkCopy.java:1566)
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.access$300(SQLServerBulkCopy.java:64)
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy$1InsertBulk.doExecute(SQLServerBulkCopy.java:662)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3206)
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.sendBulkLoadBCP(SQLServerBulkCopy.java:696)
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:1654)
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:619)
	... 2 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Source data does not match source schema.
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCSVFileRecord.getRowData(SQLServerBulkCSVFileRecord.java:267)
	at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeBatchData(SQLServerBulkCopy.java:3623)
	... 10 more

URL leieCSV = new URL("https://oig.hhs.gov/exclusions/downloadables/UPDATED.csv");
URLConnection leieCSVConnection = leieCSV.openConnection();

try(SQLServerBulkCopy bulkCopy = new SQLServerBulkCopy(conn);
    SQLServerBulkCSVFileRecord fileRecord = new SQLServerBulkCSVFileRecord(leieCSVConnection.getInputStream(), leieCSVConnection.getContentEncoding(), ",", true))
{
    fileRecord.setEscapeColumnDelimitersCSV(true);
    fileRecord.addColumnMetadata(1, "LASTNAME", java.sql.Types.VARCHAR, 20, 0);
    fileRecord.addColumnMetadata(2, "FIRSTNAME", java.sql.Types.VARCHAR, 15, 0);
    fileRecord.addColumnMetadata(3, "MIDNAME", java.sql.Types.VARCHAR, 15, 0);
    fileRecord.addColumnMetadata(4, "BUSNAME", java.sql.Types.VARCHAR, 30, 0);
    fileRecord.addColumnMetadata(5, "GENERAL", java.sql.Types.VARCHAR, 20, 0);
    fileRecord.addColumnMetadata(6, "SPECIALTY", java.sql.Types.VARCHAR, 20, 0);
    fileRecord.addColumnMetadata(7, "UPIN", java.sql.Types.VARCHAR, 6, 0);
    fileRecord.addColumnMetadata(8, "NPI", java.sql.Types.VARCHAR, 10, 0);
    fileRecord.addColumnMetadata(9, "DOB", java.sql.Types.DATE, 0, 0);
    fileRecord.addColumnMetadata(10, "ADDRESS", java.sql.Types.VARCHAR, 30, 0);
    fileRecord.addColumnMetadata(11, "CITY", java.sql.Types.VARCHAR, 20, 0);
    fileRecord.addColumnMetadata(12, "STATE", java.sql.Types.VARCHAR, 2, 0);
    fileRecord.addColumnMetadata(13, "ZIP", java.sql.Types.VARCHAR, 5, 0);
    fileRecord.addColumnMetadata(14, "EXCLTYPE", java.sql.Types.VARCHAR, 9, 0);
    fileRecord.addColumnMetadata(15, "EXCLDATE", java.sql.Types.DATE, 0, 0);
    fileRecord.addColumnMetadata(16, "REINDATE", java.sql.Types.VARCHAR, 8, 0);
    fileRecord.addColumnMetadata(17, "WAIVERDATE", java.sql.Types.VARCHAR, 8, 0);
    fileRecord.addColumnMetadata(18, "WVRSTATE", java.sql.Types.VARCHAR, 2, 0);
    
    stmt.executeUpdate("TRUNCATE TABLE exclu.oig_leie");
    bulkCopy.setDestinationTableName("exclu.oig_leie");
    bulkCopy.writeToServer(fileRecord);
}