The PeriodEnd and PeriodStart columns in an SQL Server table are designated as "Generated Always." No default value can be provided. Because Data Pump identifies the columns on the table, a default value is required. 

How can I import data into a temporal table in SQL Server?