It looks like the connection manager properties are not being set correctly by the values returned from the for each loop container. Have you tried to toggle the debug breakpoint on your data flow task and check out the connection manager relevant variables prior to the execution entering the data flow?
John Rowan
======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden