Question: how to import multiple text files into sql server?
Answer: In the package designer, select Control Flow and from the SSIS Toolbox, drag and drop a Bulk Insert Task component: Then, right-click over the Bulk Insert Task and select Edit... to configure it (You can also just double-click it).