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
Everyone has a plan until they get punched in the mouth. --Mike Tyson
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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 😀
Everyone has a plan until they get punched in the mouth. --Mike Tyson
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply