FOR EACH LOOP in SSIS - THROW ERROR WHEN ITS LOOP FINSIHED

Hi,

I've a package that developed to loop through some values. But, at the end of the loop(loop counter), package failed.

Have any one come across this kind of issue before?

Thanks
ken hanseAsked:
Who is Participating?
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hello,

The issue may be that the loop passing the values to the inner task but the value which it is passing at last loop may be with error.

Test by just putting script task inside loop and popping up that value for each loop.

may this will take you to the gate of solution
0
 
ken hanseAuthor Commented:
good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.