Wednesday, February 24, 2010

SQL Server 2008 SSIS BUG

  1. Drag and Drop the foreach Loop Container to the Control Flow task
  2. Double click
  3. Navigate to Collection tab


By default, it shows Enumerator as foreach File Enumerator. But second dialog box shown is not the parameters you should get for foreach File Enumerator.

If you want to get them, this is the workaround,

  1. Select any other Enumerator
  2. Select foreach File Enumerator again. Those parameters are back.


No comments:

Post a Comment