Foreach loop container in SSIS using variable

Question

I am using a for each loop container in SSIS package where I am passing a list object as enumerator to container. If the list is empty the for each loop container is getting failed. Is there any way to pass the container even if the list object is empty?

Edmund Schweppe · Accepted Answer · 2013-10-04 17:22:03Z

1

Is the List object you're passing to your container really an empty list, or is it null? The Foreach Loop container will quite happily iterate through an empty list (and do nothing), but will fail with an error message such as this if you try to pass it a null object:

Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80131509 "(null)". This occurs when the ForEach Enumerator cannot enumerate.

answered Oct 4, 2013 at 17:22

Edmund Schweppe

5,1421 gold badge23 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Foreach loop container in SSIS using variable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related