Create a SSIS project to import csv files to SQL Server 2016

To create a repeatable ssis project to pull in 8 csv files into SQL Server into a single [login to view URL] an audit table recording how many rows in the source and how many pulled in to the destination from each csv file. Source sample files attached. All source files have the same schema. The destination tables to populate are: 1. CREATE TABLE [dbo].[AA_Veronis_All]( [ID] [int] IDENTITY(1,1) NOT NULL, --PK [SourceFilePath] [varchar](max) NULL, -- A variable in ssis that defines where to pick up the source files from [SourceFile] [varchar](max) NULL, --Actual source File Name [RunID] [int] NULL, --Each run of the ssis package to look at the max(runid) from this table and add 1 [Access_Path] [varchar](max) NULL, -- 1st column of source file [File_Server] [varchar](max) NULL, -- 2nd column of source file [User_Group] [varchar](max) NULL, -- 3rd column of source file [Logon_Name] [varchar](max) NULL, -- 4th column of source file [Current_Permissions] [varchar](max) NULL, -- 5th column of source file [Owner_Name] [varchar](max) NULL, -- 6th column of source file [Account_Type] [varchar](max) NULL, -- 7th column of source file [InsertedDate] [datetime] NOT NULL, -- defaults to getdate() to capture the date/time the row was inserted CONSTRAINT [PK_AA_Veronis_AllUsers] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[AA_Veronis_All] ADD CONSTRAINT [DF_AA_Veronis_AllUsers_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate] GO 2. CREATE TABLE [dbo].[VerAudit]( [RunID] [int] IDENTITY(1,1) NOT NULL, --pk identity field [SourcePath] [varchar](max) NULL, -- audit the source path for each run of ssis package [SourceFile] [varchar](max) NULL, -- audit the source file for each run of ssis package [RunDate] [datetime] NULL, -- audit the run date for each run of ssis package [SourceRowCount] [int] NULL, -- audit the number of rows in the source file [DestinationRowCount] [nchar](10) NULL, -- audit the number of rows actually inserted from the source file CONSTRAINT [PK_VerAudit] PRIMARY KEY CLUSTERED ( [RunID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]