sql server - Foreach Loop Container with Foreach File Enumerator option iterates all files twice -


i using ssis foreach loop container iterate through files pattern on network share.

i encountering kind of unreproducible malfunction of loop container:

sometimes loop executed twice. after files processed starts on first file.

have encountered similar bug? maybe not directly using ssis accessing files on windows share kind of technology? error relate network issues?

thanks.

i found case whilst working excel files , using *.xlsx wildcard drive foreach.

once put logging in place noticed when excel opened produced excel file prefixed ~$. picked foreach loop.

so used trick similar http://geekswithblogs.net/compudicted/archive/2012/01/11/the-ssis-expression-wayndashskipping-an-unwanted-file.aspx exclude files ~$ in filename.


Comments

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -