November 3, 2014 at 9:52 am
I have a SSIS package that moves .xls files from one directory to and archive folder. This works perfect, but I now need to include .txt files to this package. I cannot simply use the *.* experssion, as there will be other file formats that should not be archived. I am having issues with this. Any help would be appreciated.
In the Collection properties of the Loop editor I have tried the following...
*.xls|*.txt
*.xls*,*.txt*
*.xls,.txt
The are no problems, only solutions. --John Lennon
November 3, 2014 at 11:32 am
Can you just have two loops in series? As it's looping one file at a time, there's no real performance hit.
Or (more efficiently) use instead a script task with just a few lines of code – no need for any loops.
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
November 3, 2014 at 12:26 pm
Thank you for your advice. I will go with the second loop as there is no performance hit. Plus I will only have to archive around 30 - 40 files so it should be fast.
Much appreciated 😀
The are no problems, only solutions. --John Lennon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply