How about this:
IF OBJECT_ID('tbl_FFIEC101') IS NOT NULL
DROP TABLE tbl_FFIEC101;
CREATE TABLE tbl_FFIEC101
(
[ID] Int,
[CFR ID] Varchar(20),
[Reporting Period End Date] DateTime,
[Data Source] Varchar(30),
[FDW Interface Name] Varchar(30),
[Adjustment Type] Varchar(30)
);
INSERT tbl_FFIEC101 VALUES ( 1, '100',...