Top SQL Server Tools SQL safe backup SQL compliance manager SQL diagnostic manager Data Quality Components for SQL Server SQL Developer Bundle Loop through Flat Files in SQL Server Integration Services

Several executives tell us that they will be collecting data from thousands CSV or text files and we should expect to see at least ten new files a day. Instead of trying to import each file one by one, how can we create an SSIS package that pulls the data from each file into SQL Server while being able to handle a large number of files and data? More...