Would you have any example script ?

I just gave up and used the normal file load

Reading on in the help about the exec sql task it says if you bring back more than one row you must define a variable of type object , then...

Thanks for the help so far but the for each does not seem to make sense. Once I make the setting foreach file, it now reads each file in the...

what enumerator type did you use in the foreach loop