SSIS -- Howto traverse folder sequentially using for each loop container

Question

SSIS -- Howto traverse folder sequentially using for each loop container

ravi@sql

SSCrazy

Points: 2121
More actions
November 22, 2015 at 10:45 pm

#313365

HI Champs,
Am having three folders in sequence each folder having 3 files each, am using Foreach loop container to traverse all these three folders.
But its not traversing sequentially ? what should i do for this ? help me to resolve this issue ?
Regards,
Ravi 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Can you define "sequentially"? If it isn't processing the folders in parallel then technically it is processing them sequentially. I have to assume you want the folders to be processed in a specific order. I believe by default the foreach loop will process them in alpha order.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question