Post reply

For Each loop Container with Excel Source in Data Flow Task- Setting variable for Multiple files

  • August 6, 2008 at 2:28 pm

    #124637

    I have a feeling there is just something small I am missing. I was able to set up a foreach loop container using a variable when the source was a flat file. But I can't seem to figure out how to set the variable up for the excel connection. I am thinking I need two variables one for the file name and one for the sheet name but I can't figure how to set that up. Can anyone help? My project is that I need to import multiple excel files from one folder into the database and then move them to a new folder when they are finished importing.

    Thanks in advance for any help

  • August 7, 2008 at 4:23 am

    #854332

    the filepath points to the file. the sheet name is used in the select statement. you may need to build the select statement dynamically using either a script task or a variable evaluated as an expression.

    tom

    Life: it twists and turns like a twisty turny thing

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply