I still don't know how to wire in the outer loop data into the inner loop. The inner loop in SSIS requires input columns but I'm not using records, I want to use memory variables as input.
Pseudo code
--OuterLoop
ForEach Row in DataTbl
StartIndex = DataTbl.StartNo
StopIndex = DataTbl.EndNo
SourceIndex = StartIndex
IterationCnt = StopIndex - StartIndex + 1
FullName = DataTbl.FullName
-- Inner Loop / Uses memory variables (no input column source so how to connect this in SSIS?)
for x = 1 to IterationCnt
writeflatfile "COPY \IMG\PICT" + PAD(SourceIndex,4,"0") + ".jpg \target\"+FullName+"\"+FullName+"_"+pad(x,4,"0")+".jpg"
SourceINdex = SourceIndex + 1
next x
Next Row
I'm at that point in the learning curve where it's frustrating and hard to see why they even went to a click and drag component model when code is just a matter of saying what you want.
Thanks for helping -- I know this must seem obvious to you.