Post reply

SSIS 2012 Foreach file enumerator issue

  • October 10, 2016 at 12:43 pm

    #330832

    All variables are dynamic, passing Directory and FileSpec

    Checked going in via debug, moved 1 file to the archive which meets the criteria.

    Get warnings that "Warning: 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."

    How can I find out what is being done internally ? Is there a trap for more specific error codes ?

    Thanks

  • October 10, 2016 at 1:00 pm

    #1905761

    Did you check to make sure that the agent has permissions to access the directory where the files are stored?

    The last time I worked with SSIS was SQL 2008, so things may have changed, but there was an option to turn on logging which would record information that was useful in troubleshooting. I don't remember what it logged.

    Also, you posted this in a SQL 2014 forum, but the header says SSIS 2012.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • October 10, 2016 at 1:14 pm

    #1905767

    I'm running from my desktop, directory is UNC, there is a LoggingMode in the

    Property Expressions Editor, but have found NO documentation on it...

    Sorry about the forum post, can it get moved to the appropriate forum ?

    Thanks

  • October 20, 2016 at 10:05 am

    #1907709

    Found issue, Search was passed to C# via ssis variable.

    Works if I defined , populated and used variable local to C# but

    not if I used variable passed in.

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

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