CODEWITHSUNDEEP
ssisforeach-loop-container
Jeff
Jeff

Reputation: 53

SSIS - For each loop not stopping

I make For Each Loop container to store file name (from directory) to SQL table. It works fine until i put it inside Execute Task. My problem is, after put it inside Execute Task, the For Each Loop container run forever (non stop loop) and it is not going to the next process.

Below is the For Each Loop Container and I put it inside the execute package task on picture 2

I use variable in For Each Loop to store the files directory and insert it on table using Execute SQL Task Execute Package Task enter image description here

For Each Loop

Is there some setting or properties need to set?

Thanks

Upvotes: 0

Views: 365

Answers (0)

Related Questions