none
How to load a singe XML file but the name of the file changes everyday RRS feed

  • Question

  • Hi,
    I need to load a single XML file into SQL server table on daily basis.This file's
    naming convention is like 'Order_yyyymmddhhmmss.xml'. The dd part will change everyday that we can assume on daily basis. But hhmmss part also changes everyday and we never know that.  So, the file name is not constant. But the first part is Order_ is constant. I have a question

    I have to go for ForEachLoop container even though its a single file , because the file name is NOT constant - is that correct?
    Tuesday, June 18, 2019 5:35 PM

All replies

  • Hi Revathy,

    Yes, correct.

    And the file name mask would be Order_*


    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Olaf HelperMVP Wednesday, June 19, 2019 6:20 AM
    Tuesday, June 18, 2019 6:02 PM
    Moderator
  • Hi Revathy,

    Yes, you should use Foreach Loop Container and choose Foreach File Enumerator, then set Files as Order_*.xml .

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by Olaf HelperMVP Wednesday, June 19, 2019 6:20 AM
    Wednesday, June 19, 2019 1:53 AM