Post reply

The For Each File enumerator is empty in SSIS

  • October 10, 2016 at 11:31 am

    #318133

    Hi,

    I am trying to load an excel file and update it on the database inside the for each loop in SSIS. When i execute the For each loop container individually it was working fine. But if i execute the whole control flow it gives "Warning: 0x8001C004 at Process Pricing Excel files: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty.". I double checked with file path and extensions. Everything seems good and there is a file exists in the folder. But not sure what's wrong with this. Can someone suggest me on how to go about this?

    Thanks

  • October 10, 2016 at 11:49 am

    #1905736

    sappidi06 (10/10/2016)

    Hi,

    I am trying to load an excel file and update it on the database inside the for each loop in SSIS. When i execute the For each loop container individually it was working fine. But if i execute the whole control flow it gives "Warning: 0x8001C004 at Process Pricing Excel files: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty.". I double checked with file path and extensions. Everything seems good and there is a file exists in the folder. But not sure what's wrong with this. Can someone suggest me on how to go about this?

    Thanks

    Are there any Expressions defined for the Foreach Loop container? You need to check in two places:

    1) The outer object and

    2) Under Collection/Foreach loop editor / Expressions.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • October 10, 2016 at 12:20 pm

    #1905745

    I have the expressions defined in

    1)Collection> Enumerator Configuration: Folder: C:\Users\ssappidi\Desktop\Uploads and 2)Foreach Loop Editor>Expressions> Directory @[User::FolderName]

    Also i have declared a FolderName Variable and gave the path of my file in it. Let me know if there is any other location i have to specify the path?

  • October 10, 2016 at 12:40 pm

    #1905752

    sappidi06 (10/10/2016)

    I have the expressions defined in

    1)Collection> Enumerator Configuration: Folder: C:\Users\ssappidi\Desktop\Uploads and 2)Foreach Loop Editor>Expressions> Directory @[User::FolderName]

    Also i have declared a FolderName Variable and gave the path of my file in it. Let me know if there is any other location i have to specify the path?

    Your Foldername variable should not contain a file path. It should contain a folder path (eg C:\Users\ssappidi\Desktop\Uploads\).

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • October 10, 2016 at 1:58 pm

    #1905777

    Sorry, I have given the folder path only.

Viewing 5 posts - 1 through 4 (of 4 total)

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