Import more than one excel file using SSIS (Dynamically)



    I have one share folder ,every month end-user will copy & paste excel file into particular share folder. Ok .

    Now i have to create new SSIS package as schedule should run every month to find the file and then load automatically into Sql server tables and then move those excel file to another share folder if file successfully loaded only.

       The excel file name will be changing every month. but the format wont change. If any body knows this process or steps.

    Please share with me .


    Thanks in Advance.


    Thursday, December 06, 2007 2:47 PM


All replies