February 1, 2019 at 8:56 am
Can anyone help or point me in the right direction.
I have an ssis package that uploads multiple files an process them, but there is a For Each Loop for each filename because the Files can be Orange, Apple, Pineapple etc., What I was thinking that if I upload the file and create a variable to hold the Fruit, and if the fruit is in my list, then upload the file, but if the fruit isn't in the list, don't upload it. I've worked out how to extract the Fruit from the filename into a variable, but I am not sure how to compare that to a list, and give it a true or false so I can process the file if true, or ignore the file if false.
Has anyone done anything like this before?
Would appreciate any pointers
February 1, 2019 at 9:41 am
Are the list items held in a database table?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
February 4, 2019 at 1:03 am
No, I just have a manual list of the filenames with fruits in them, though I can make a list and hold it in a table if I needed to
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply