Question: how to import multiple excel files in ssis?
Answer: CREATE TABLE [dbo].[ SSISDataImport]( [EmpID] [int] NULL, [EmpName] [varchar](50) NULL, [Source] [nvarchar](50) NULL. ) ON [PRIMARY]