SSIS Package with variables for Multiple Excel files

• sql1411

  Ten Centuries

  Points: 1390

  More actions

  November 6, 2013 at 9:46 am

  #278912

  I've a simple SSIS package with a ScriptTask and SendEmailTask. ScriptTask is used to simply OPEN an EXCEL file (for eg filename.xls) in a certain location and RE-SAVES it to the same location. Once the file is resaved, SendEmailTask sends and email.

  I've used two valiables in this package such as FilePath and EmailToGroups.

  There is a SQL jobs that runs every morning at 6 am to execute this package.

  Now, I'm getting 4 more new excel file in this location. So, I was wondering instead of creating 4 new packages, is there a way to do this with one single package?

  Any guidance or suggestions is much appreciated.

  Thanks in advance

• derekredmon

  SSC Enthusiast

  Points: 170

  More actions

  November 8, 2013 at 8:31 am

  #1665140

  You should be able to accomplish this by:

  1) Using a For Each Loop Container. This will allow you to use your current 2 variables and not have to add any others.

  or

  2) Add more "FilePath" (and "EmailToGroup" if necessary) variables to hold the values of each of your new files.