You could use a for each file enumerater to loop around each file in the folder. Inside this loop you will have a Data Flow task that picks up the data and pumps to the table.

You can use expressions on the connection managers to change the filename/db connection for each loop. Artytorrent Pack 73-x-mix Studio 2 House 130-139bpm-wav. (This is assuming each file has the same schema) If the files do not have the same schema, then I recommend calling a child package for each file type, and then calling that child package inside the loop, rather than a data flow task. I put together a video example a while ago, about how to change file name dynamically.

Statistics And Econometric Models Volume 1 Pdf. The scenario was slightly different but it will hopefully point you in the right direction. The link is Hope this helps.