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]