July 22, 2009 at 9:25 am
As a best practice at work we use the foreach loop container to find files to load onto our data warehouse. We do this because we don't know the number of files we may receive on a given day (if we receive any at all). However, today I noticed what I believe is a bug in the foreach loop container. If you specify a folder that does not exist in the enumerator configuration, SSIS does not throw an error. It shows the process as successful but does not execute any contents. That would be ok if no files existed, but in this case the folder does not exist.
Is my thinking wrong on this?
J.D.
July 22, 2009 at 9:29 am
I can see your point but there is another side to it. Since no folder exists then no files exist either. So I don't know if I would classify it as a bug.
July 22, 2009 at 9:34 am
Indeed, no doubt classed as a feature 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply