Hi @Carlton Patterson ,
The data types of many columns in your table are not in the correct time/date format, so the error you see will be returned when inserting data.
I modified the data type of your column, please refer to:
CREATE TABLE dimDate
(DATE_KEY DATETIME NULL,DAY_OF_WEEK INT NULL,DAY_NUM_IN_MONTH INT NULL
,DAY_NUM_OVERALL INT NULL,DAY_NAME CHAR(15) NULL,DAY_ABBREV CHAR(15) NULL
,WEEKDAY_FLAG CHAR(15) NULL,WEEK_NUM_IN_YEAR INT NULL,WEEK_NUM_OVERALL DATETIME NULL
,WEEK_BEGIN_DATE DATETIME NULL,WEEK_BEGIN_DATE_KEY DATETIME NULL,MONTH INT NULL
,MONTH_NUM_OVERALL DATETIME NULL,MONTH_NAME CHAR(15) NULL,MONTH_ABBREV CHAR(15) NULL
,MONTH_YEAR CHAR(15) NULL,QUARTER INT NULL,YEAR INT NULL
,YEARMO DATETIME NULL,FISCAL_MONTH INT NULL,FISCAL_QUARTER INT NULL
,FISCAL_YEAR INT NULL,LAST_DAY_IN_MONTH_FLAG CHAR(15) NULL,SAME_DAY_YEAR_AGO DATETIME NULL
,WORKING_DAY_FLAG CHAR(15) NULL,DDMMYY_DATE DATETIME NULL,MONYY_DATE CHAR(15) NULL
,YEAR_QUARTER CHAR(15) NULL,FISCAL_YEAR_QUARTER CHAR(15) NULL,LAST_DAY_IN_WEEK_FLAG CHAR(15) NULL
,LAST_DAY_IN_QUARTER_FLAG CHAR(15) NULL,LAST_DAY_IN_FISCAL_YEAR_FLAG CHAR(15) NULL
,FISCAL_WEEK_NUM INT NULL,WORKING_DAY_SCOTLAND_FLAG DATETIME NULL
) ON [PRIMARY]
GO
Insert into dimDate values
(convert(DATE,'11-SEP-01',104),2,11,254,
'Tuesday ','Tue','Y',37,null,
convert(DATE, '10-SEP-01',104),
convert(DATE,'20010910',104),9,null,
'September','Sep','September 2001',3,
2001,200109,6,2,2001,'N',
convert(DATE,'11-SEP-00',104),
'Y','11/09/01','Sep 01','2001-Q3',
'2001-Q2','N','N','N',24,null);
SELECT * FROM dimDate
If you have any question, please feel free to let me know.
Regards
Echo
If the answer is helpful, please click "Accept Answer" and upvote it.