SQL SSIS issue: How to Process multiple files with different names
Posted on 2008-10-04
I have a 2 questions that I need help with.
First, I have this SSIS package that takes an Excel file (enrollment.xls) from a server share and imports it into a SQL database, then it deletes it from the server share. The idea is that someone will create this enrollment.xls file and place it on the server share to be processed. However, the problem with this approach is that there can only be one file in that location at any given time. How do I go about programming the SSIS package to look for every file in the folder and process each? The file does not need to be called enrollment.xls.... it can enrollment1.xls, enrollmentB.xls. This way people can pop as many files in there to be processed and I can then schedule this SSIS package to run at night.