none
how to set multiple file extension in ForEach Loop Component.

Answers

All replies

  • Hi,

    use *.xls* :-)

    -Jens


    Jens K. Suessmeyer http://blogs.msdn.com/Jenss

    • Marked as answer by Andrea Pirlo Friday, June 20, 2014 2:22 AM
    Wednesday, June 18, 2014 9:25 PM
  • even *.xls while work to get both xlsx and xls (like in DOS)

    But what are you doing in the loop? A Data Flow Task with an Excel source could give some problems because the both use different providers...


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Wednesday, June 18, 2014 9:47 PM
  • This is correct, even after you have enumerated over the marked (xls and xlsx files) how do you intend to process these files. What are the subsequent tasks in the for each loop?

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog


    • Edited by Raunak J Thursday, June 19, 2014 5:09 AM
    Thursday, June 19, 2014 5:09 AM
  • This is correct, even after you have enumerated over the marked (xls and xlsx files) how do you intend to process these files. What are the subsequent tasks in the for each loop?

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog


    can the excel data provider process both xlsx and xls file?
    is there any way to process  both xlsx and xls file in dataflow?
    Thursday, June 19, 2014 9:22 AM