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.
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy